NTSB investigations, 2001
8 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 102 |
|---|---|
| 1983 | 62 |
| 1984 | 60 |
| 1985 | 45 |
| 1986 | 35 |
| 1987 | 44 |
| 1988 | 30 |
| 1989 | 30 |
| 1990 | 22 |
| 1991 | 20 |
| 1992 | 33 |
| 1993 | 36 |
| 1994 | 43 |
| 1995 | 30 |
| 1996 | 28 |
| 1997 | 28 |
| 1998 | 16 |
| 1999 | 21 |
| 2000 | 17 |
| 2001 | 8 |
| 2002 | 14 |
| 2003 | 19 |
| 2004 | 18 |
| 2005 | 24 |
| 2006 | 13 |
| 2007 | 22 |
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\") = 2001
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\" = 390)
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") = 2001 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" = 390) 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 LAX02LA024Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Copperopolis, CAThe pilot's misjudgment of speed and altitude on final approach to landing, which resulted in a low approach and impact with a fence at the runway threshold. The impact lead to a subsequent loss of control and nose over.NTSB CHI01LA317Accident · No injuriesLimited investigationFinal reportBeech 200 · Indianapolis, INThe pilot not maintaining the proper ILS glide slope during the approach and the pilot not executing a missed approach. Contributing to the accident was the rain/mist.NTSB IAD01LA043Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Painesville, OHThe pilot's failure to maintain the proper descent rate and the flight instructor's inadequate supervision.NTSB LAX01LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gila Bend, AZFailure of the CFI to properly supervise the flight and the failure of the dual studen to maintain flying airspeed. A contributing factor was the wind shear encountered.NTSB CHI01LA096Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Appleton, WIThe misjudged glidepath and the intentional engine shutdown by the pilot. Factors were the false indication of the landing gear down light and the approach light.NTSB NYC01LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe pilot's failure to attain the proper touchdown point. Factors included the nighttime conditions, and the pilot's improper decision to leave the runway lighting at high intensity.NTSB CHI01LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe CFI's delay in iniating remedial action to arrest the sink rate which developed on final approach. Factors associated with the accident were the student pilot failed to maintain a proper glidepath on final approach and the snow bank which the airplane…NTSB ANC01LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Atmautluak, AKThe pilot's failure to maintain a proper glidepath during final approach. A factor associated with the accident was soft terrain.