NTSB investigations, 2006
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\") = 2006
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") = 2006 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 NYC07FA051Accident · 2 fatalField investigationFinal reportCessna 414 · Johnstown, PAThe pilot's improper decision to abort the landing with a damaged airplane. Contributing to the accident were the damage from the airplane's impact with the runway, the pilot's failure to lower the landing gear prior to the landing attempt, and the in-flight…NTSB CHI07LA036Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Coalton, OHThe pilot failed to follow the checklist and lower the landing gear. A factor in the accident was the fence post.NTSB SEA07LA030Accident · No injuriesLimited investigationFinal reportCessna P210N · Burns, ORThe pilot's failure to put the landing gear down for landing.NTSB MIA07FA005Accident · No injuriesField investigationFinal reportBritish Aerospace HS 125-700A · Fort Lauderdale, FLThe failure of the flight crew to extend the landing gear. Contributing to the accident was the inoperative audible landing gear warning system.NTSB LAX07LA019Accident · No injuriesLimited investigationFinal reportCessna 310N · Lake Havasu Cit, AZthe pilot's failure to extend the landing gear prior to touchdown.NTSB MIA06CA139Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Fort Lauderdale, FLThe inadequate installation of a flexible hydraulic hose at the nose landing gear actuator by an unknown person resulting in the total loss of hydraulic fluid, the inability of the pilot to extend the landing gear, and subsequent wheels-up landing.NTSB CHI06CA265Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Dayton, OHThe pilot's inadvertent wheels up landing.NTSB DFW06CA203Accident · No injuriesData collectionFinal reportPiper 601P · Lubbock, TXThe pilot's failure to extend the landing gear while on final approach.NTSB LAX06CA239Accident · No injuriesData collectionFinal reportCessna 177RG · Camarillo, CAthe pilot's failure to extended the landing gear and verify the proper landing gear configuration prior to landing, resulting in a gear-up landing.NTSB DEN06CA101Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Olathe, KSthe pilot's failure to extend the landing gear prior to landing.NTSB ANC06LA093Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Fairbanks, AKThe pilot's inadvertent landing with the landing gear retracted, which resulted in structural damage to the airplane.NTSB CHI06CA140Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Jackson, MIThe pilot's inadvertent wheels up landing.NTSB NYC06CA113Accident · No injuriesData collectionFinal reportCessna 310C · Allentown, PAThe pilot's failure to lower the landing gear during landing.NTSB MIA06LA105Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Marathon, FLThe pilot's failure to extend the landing gear prior to landing, which resulted in the propellers striking the runway, an aborted landing, and an in-flight collision with terrain.NTSB SEA06CA097Accident · No injuriesData collectionFinal reportRupp Rutan Defiant · Coeur d'Alene, IDThe pilot's failure to put the nose wheel landing gear down for landing.NTSB LAX06CA160Accident · No injuriesData collectionFinal reportBeech C24R · Sacramento, CAthe pilot's failure to complete and verify the prelanding checklist and extend the landing gear, which resulted in a gear up landing. A contributing factor was the pilot's diverted attention during the approach.NTSB LAX06CA119Accident · No injuriesData collectionFinal reportBeech 95 · Kingman, AZthe flight instructor's failure to perform the before landing checklist and extend the landing gear prior to touchdown. A contributing factor was the pilot's diverted attention with another airplane that had departed from the opposite runway.