NTSB investigations, 1999
17 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\") = 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\" = 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") = 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" = 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 NYC00LA046Accident · No injuriesLimited investigationFinal reportCessna 210L · Columbus, OHThe pilot's failure to verify landing gear extension. Factors were the unreliable retraction/extension assembly, and the flying club's continued operation of the airplane with known deficiencies in the equipment.NTSB MIA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182RG · Jacksonville, FLThe pilot's failure to complete the before landing checklist and extend the landing gear, resulting in a gear up landing. A factor in the accident is the failure of the landing gear warning circuit to activate the cockpit warning horn.NTSB CHI00LA029Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Romulus, MIthe inadvertent wheels-up landing by the pilot.NTSB SEA00LA011Accident · No injuriesLimited investigationFinal reportBeech A36TC · Pasco, WAThe pilot's failure to extend the landing gear. Factors include a blocked view of the landing gear light indicating system.NTSB FTW00LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oklahoma City, OKThe failure of the pilot to follow the landing checklist and verify that the landing gear was down and locked, which resulted in a wheels up landing. A factor was the failure of the landing gear locking mechanism for an undetermined reason.NTSB CHI99LA315Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Eden Prairie, MNthe failure of the pilot to follow the landing checklist and his failure to extend the landing gear.NTSB LAX99LA278Accident · No injuriesLimited investigationFinal reportCessna TR182 · S. Lake Tahoe, CAThe pilot's failure to verify the landing gear was in the extended position. A factor in the accident was gear warning system's unresolved discrepancies.NTSB DEN99LA151Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Albuquerque, NMThe pilot's failure to follow published procedures in operating the aircraft. A factor was partial failure of the electrical system.NTSB FTW99FA223Accident · No injuriesField investigationFinal reportSwearingen SA-227-AC · San Antonio, TXThe instructor pilot's failure to complete the Emergency Gear Extension Checklist, resulting in the inadvertent wheels-up landing. A factor was the instructor pilot's fatigued condition.NTSB DEN99LA127Accident · No injuriesLimited investigationFinal reportCessna T210F · Albuquerque, NMThe pilot's inadvertent wheels up landing.NTSB ANC99LA085Accident · No injuriesLimited investigationFinal reportCessna 177RG · Fairbanks, AKThe pilot's failure to extend the airplane landing gear. A factor in the accident was an interference with the pilot's habit pattern.NTSB CHI99LA206Accident · No injuriesLimited investigationFinal reportBeech 58 · Wheeling, ILthe landing gear extension not performed by the pilot. A contributing factor was the checklist not followed by the pilot.NTSB MIA99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Fort Myers, FLThe pilot's failure to verify that the retractable landing gear were down and locked for landing.NTSB SEA99LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Plentywood, MTThe pilot's failure to ensure that the landing gear were properly down and locked for landing.NTSB CHI99LA173Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Effingham, ILinadvertent wheels-up landing and the checklist not followed by the pilot. The landing gear lever not engaged was an additional cause.NTSB ATL99LA086Accident · No injuriesLimited investigationFinal reportBeech BE-100 · Hickory, NCThe failure of the landing gear actuator due to the improper installation of the lower thrust bearing by maintenance personnel.NTSB LAX99LA130Accident · No injuriesLimited investigationFinal reportBeech 58 · Atwater, CAthe failure of the student to extend the landing gear and the flight instructor's inadequate supervision of the flight.