NTSB investigations, 1999
9 cases where the first occurrence was “Forced landing”.
Cases per year
| 1982 | 10 |
|---|---|
| 1983 | 11 |
| 1984 | 6 |
| 1985 | 15 |
| 1986 | 8 |
| 1987 | 11 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 13 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 5 |
| 1999 | 9 |
| 2000 | 3 |
| 2001 | 5 |
| 2004 | 4 |
| 2005 | 1 |
| 2006 | 6 |
| 2007 | 7 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 1999
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 180)
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 1999 AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 180) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX00LA054Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Concord, CAthe pilot's failure to use a checklist and remove the control gust lock.NTSB ANC00LA017Accident · No injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe pilot's inadequate preflight and his failure to remove snow and airframe ice from the airplane.NTSB NYC00LA042Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Discus A · Palmerton, PAThe pilot's improper decision to delay his landing. A factor related to the accident was the loss of thermal lift.NTSB DEN00LA006Accident · No injuriesLimited investigationFinal reportKendall/Mckaughlin Rans S-10 Sakota · Hudson, COInadequate preflight planning when the pilot failed to evaluate aircraft performance and weather. Factors were high density altitude, and unsuitable terrain for a forced landing.NTSB DEN99LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Panguitch, UTInadequate preflight planning and preparation by the pilot in command. Factors were high velocity gusty winds, high-density altitude, and unsuitable terrain for a forced landing.NTSB DEN99LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Aspen, COThe pilot's inadequate in flight planning. Factors were the high density altitude, the lack of suitable terrain for a forced landing, and the sign post that the right wing impacted.NTSB MIA99LA197Accident · No injuriesLimited investigationFinal reportLet L-23 · Jacksonville, FLthe pilot's improper in-flight decisions allowing the glider to descend to a low altitude, resulting in a forced landing off the airport and subsequent impact with a tree.NTSB CHI99LA178Accident · Serious injuriesLimited investigationFinal reportRobinson R-22 · Salem, MOthe engine quit due to water contamination of the fuel and the pilot's inadequate preflight.NTSB DEN99LA055Accident · No injuriesLimited investigationFinal reportCessna 310L · Angel Fire, NMThe pilot's exceeding the airplane's weight and balance limitations. A factor was the high density altitude weather condition.