NTSB investigations
203 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 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 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 NYC08CA073Accident · No injuriesData collectionFinal reportPiper PA-31T · Muscle Shoals, ALThe pilot's failure to lower the landing gear.NTSB SEA08LA025Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Salt Lake City, UTThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's failure to use a written checklist.NTSB DEN08LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Trinidad, COThe pilot's failure to extend the landing gear.NTSB DFW07CA209Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Pampa, TXThe pilot's failure to extend the landing gear prior to landing.NTSB SEA07CA268Accident · No injuriesData collectionFinal reportMooney M20D · Placerville, CAThe pilot's failure to extend the landing gear prior to landing. A contributing factor was the pilots impaired performance.NTSB LAX07CA255Accident · No injuriesData collectionFinal reportBeech D55 · Heber, UTThe pilot's failure to lower the landing gear during landing.NTSB DEN07CA116Accident · No injuriesData collectionFinal reportCessna T210N · Loveland, COThe pilot's failure to lower the landing gear. Contributing factors were the pilot's attention being diverted, and his failure to use the BEFORE LANDING checklist.NTSB LAX07CA196Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Boulder City, NVthe pilot's failure to extend the landing gear.NTSB DFW07CA132Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Madison, MSThe pilot's failure to extend the landing gear prior to landing.NTSB DFW07LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Rockport, TXThe pilots improper landing flare which resulted in a hard landing. Contributing factors were the pilot's delayed actions to abort a wheels-up landing.NTSB LAX07CA159Accident · No injuriesData collectionFinal reportCessna T210L · The Dalles, ORThe pilot's failure to extend the landing gear.NTSB CHI07CA109Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Walker, MNThe pilot's inadvertent failure to lower the landing gear.NTSB MIA07LA068Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-83 (MD-83) · Sanford, FLThe flight crew's failure to complete the checklist and adhere to airplane placards. Contributing to the accident was a separation of a B-nut on the rudder power hydraulic shut off valve for undetermined reasons.NTSB LAX07CA110Accident · No injuriesData collectionFinal reportCessna T210N · Barstow, CAThe pilot's failure to properly execute the manual landing gear extension procedures.NTSB CHI07CA088Accident · No injuriesData collectionFinal reportPiper PA-24-400 · Des Moines, IAthe nose landing gear becoming jammed in a partially extended position during flight as a result of damage to the nose landing gear by ground personnel.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.NTSB LAX06LA034Accident · No injuriesLimited investigationFinal reportBeech H35 · Kingman, AZa touchdown with the gear partially extended. A factor in the accident was an inoperative landing gear warning horn.NTSB ATL06LA014Accident · 1 fatalLimited investigationFinal reportMooney M20M · Summerville, SCThe pilot's failure to follow the pre-landing checklist which resulted in a gear up landing and subsequent propeller strike. The pilots improper decision to attempt a go-around after the propeller strike, resulted in a loss of engine power and subsequent…NTSB LAX06CA028Accident · No injuriesData collectionFinal reportLearjet 25D · Sacramento, CAthe pilot's failure to extend the landing gear and to verify they were in the down and locked position prior to touchdown. A related factor was his diverted attention.NTSB LAX05CA304Accident · No injuriesData collectionFinal reportBeech 95-B55 · Porterville, CAthe pilot's failure to extend the landing gear prior to landing.NTSB CHI05CA258Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Fertile, MNThe flightcrew's failure to extend the landing gear prior to touchdown, and the flight instructor's inadequate supervision of the flight.NTSB DFW05CA206Accident · No injuriesData collectionFinal reportCessna 182T · Houston, TXThe gear-up landing as result of the separation of the hydraulic line in the landing gear extension system.NTSB DEN05CA134Accident · No injuriesData collectionFinal reportEclipse HXB · Albuquerque, NMthe pilot's failure to extend the landing gear prior to landing. A contributing factor was the pilot's failure to complete the before landing checklist.NTSB ANC05LA130Accident · No injuriesLimited investigationFinal reportCessna 441 · Anchorage, AKThe pilot's failure to lower the airplane's landing gear during landing, which resulted in an inadvertent wheels up landing.NTSB IAD05FA125Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · West Chester, PAThe pilot's improper decision to abort the landing after the airplane contacted the runway. A factor in the accident was the pilot's failure to ensure the landing gear was extended during the landing.NTSB DCA05MA095Accident · Minor injuriesMajor investigationFinal reportBoeing 747-200 · Aganathe flight crews' failure to verify that the number of landing gear annunciations on the second officer’s panel was consistent with the number specified in the abnormal/emergency procedures checklist, which led to a landing with the nose gear retracted.NTSB LAX05LA198Accident · No injuriesLimited investigationFinal reportCessna 210 · Watsonville, CAthe pilot's failure to extend the landing gear prior to landing.NTSB ANC05CA078Accident · No injuriesData collectionFinal reportPiper PA-31-310 · Manokotak, AKThe pilot's failure to extend the landing gear. A contributing factor was the pilot's failure to use the checklist.NTSB DFW05CA122Accident · No injuriesData collectionFinal reportBeech BE-55 · Midland, TXThe pilot's failure to extend the landing gear which resulted in a gear-up landing. A contributing factor was the pilot's failure to follow the checklist.NTSB SEA05CA078Accident · No injuriesData collectionFinal reportShannon Lancair Legacy 2000 · Bend, ORThe pilot's failure to put the landing gear down for landing.NTSB LAX05LA178Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-26A · Blythe, CAthe pilot's failure to lower the landing gear prior to landing. A factor to the accident was the pilot's diverted attention due to the flap system anomaly.NTSB NYC05LA056Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Millville, NJThe flight instructor's failure to lower the landing gear during landing.NTSB MIA05CA047Accident · No injuriesData collectionFinal reportCessna TR182 · Vicksburg, MSThe pilot's failure to extend the landing gear which resulted in a wheels up landing. A contributing factor is the pilot's failure to complete the checklist.NTSB MIA05CA034Accident · No injuriesData collectionFinal reportBeech 58 · Fort Pierce, FLThe failure of the pilot to follow the checklist and extend the landing gear during landing resulting in a gear-up landing.