NTSB investigations, CA
21 cases where the first occurrence was “Wheels up landing”.
Cases per year
| 1995 | 1 |
|---|---|
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2001 | 3 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 2 |
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' 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 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 LAX07CA110Accident · No injuriesData collectionFinal reportCessna T210N · Barstow, CAThe pilot's failure to properly execute the manual landing gear extension procedures.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 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 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 LAX05LA198Accident · No injuriesLimited investigationFinal reportCessna 210 · Watsonville, CAthe pilot's failure to extend the landing gear prior to 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 LAX04CA263Accident · No injuriesData collectionFinal reportCessna R182 · California City, CAthe pilot's failure to lower the landing gear. A contributing factor was the pilot's distraction while on final approach.NTSB LAX03CA203Accident · No injuriesData collectionFinal reportMooney M20J · Lincoln, CAThe pilot's failure to extend the landing gear prior to landing.NTSB LAX03LA194Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Inyokern, CAThe pilot failed to extend the landing gear.NTSB LAX01LA177Accident · No injuriesLimited investigationFinal reportBeech E33A · So Lake Tahoe, CAThe pilot's improper aircraft handling and decision to prematurely raise the landing gear during takeoff. Contributing factors were his lack of experience taking off under the high density altitude condition and his improper maintenance.NTSB LAX01LA148Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Chino, CAThe pilot's failure to extend the landing gear. A factor was the pilot's failure to use the landing checklist.NTSB LAX01LA082Accident · No injuriesLimited investigationFinal reportBeech BE-55 · San Bernardino, CAThe failure of the pilot under instruction to extend the landing gear during the landing approach. A factor was the flight instructor's inadequate supervision.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 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.NTSB LAX98LA105Accident · No injuriesLimited investigationFinal reportLearjet 23 · Oakdale, CAfailure of the flight crew to extend the landing gear before landing.NTSB LAX98LA065Accident · No injuriesLimited investigationFinal reportCessna 172RG · Van Nuys, CAThe student and flight instructor's failure to verify that the landing gear was in the down position, and the design of the electrical system in which a single-point aircraft system malfunction (one open circuit breaker) disabled both the landing gear warning…NTSB LAX97LA263Accident · No injuriesLimited investigationFinal reportBeech V35B · Pacoima, CAThe pilot's failure to ensure that the landing gear was lowered before touchdown.NTSB LAX96LA165Accident · No injuriesLimited investigationFinal reportCessna T210N · Paradise, CAthe pilot's failure to follow landing gear extension procedures by not confirming that the gear was fully extended prior to touchdown. A contributing factor was the interference/alteration of the pilot's customary habit pattern due to his response to a…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.