NTSB investigations, 1995
12 cases where the first occurrence was “Wheels up landing”.
Cases per year
| 1993 | 2 |
|---|---|
| 1994 | 2 |
| 1995 | 12 |
| 1996 | 12 |
| 1997 | 12 |
| 1998 | 17 |
| 1999 | 17 |
| 2000 | 18 |
| 2001 | 21 |
| 2002 | 19 |
| 2003 | 10 |
| 2004 | 13 |
| 2005 | 16 |
| 2006 | 17 |
| 2007 | 15 |
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\") = 1995
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\" = 232)
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") = 1995 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" = 232) 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 CHI96LA053Accident · No injuriesLimited investigationFinal reportSwearingen SA-226AT · Detroit, MIthe pilot's failure to extend the landing gear. A factor in the accident was the pilot's diverted attention.NTSB LAX96LA047Accident · No injuriesLimited investigationFinal reportBeech D-50 · Jackson, CAthe failure of the pilot-in-command to follow the pre-landing checklist which resulted in his failure to extend the landing gear and an inadvertent wheels-up landing.NTSB FTW96LA047Accident · No injuriesLimited investigationFinal reportCessna 210B · Loveland, COFailure of the pilot to extend the landing gear.NTSB MIA96LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Fort Lauderdale, FLThe pilot's failure to follow procedures, resulting in the airplane being landed with the landing gear in the up position.NTSB CHI96LA021Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Indianapolis, INthe pilot's failure to lower the landing gear. Factors which contributed to the accident were: inadequate preflight necessitating a precautionary landing and the pilot's failure to use the pre-landing checklist.NTSB SEA96LA011Accident · No injuriesLimited investigationFinal reportCessna 210L · Lincoln, MTThe failure of the pilot to follow the landing checklist and assure that the landing gear was extended. Factors relating to the accident were: the pilot's diverted attention, and an inoperative landing gear warning system.NTSB FTW95LA353Accident · No injuriesLimited investigationFinal reportBeech 35N · Creede, COFailure by the pilot to follow the checklist and lower the landing gear.NTSB NYC95LA149Accident · No injuriesLimited investigationFinal reportMooney 20E · Burlington, CTthe pilot's failure to extend the landing gear resulting in a wheels up landing. A factor relating to the accident was the inoperative gear warning horn.NTSB MIA95LA153Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Opa-Locka, FLThe failure of maintenance personnel to comply with manufacturer inspection procedures for hydraulic lines resulting in the failure of the right main gear door line and loss of all hydraulic fluid.NTSB CHI95LA109Accident · No injuriesLimited investigationFinal reportBeech 58 · Grand Rapids, MIthe failure of the landing gear bushing for the actuator worm gear which resulted in both the normal and emergency gear extension systems being inoperative.NTSB FTW95LA133Accident · No injuriesLimited investigationFinal reportCessna 337C · Porter, TXThe pilot's failure to extend the landing gear. Factors were his failure to use a checklist and his diverted attention.NTSB ATL95LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Burnsville, NCThe pilot's failure to complete the before-landing checklist to ensure that the landing gear was extended.