NTSB investigations, MS
10 cases where the first occurrence was “Wheels up landing”.
Cases per year
| 1997 | 2 |
|---|---|
| 1998 | 1 |
| 2001 | 1 |
| 2003 | 2 |
| 2004 | 3 |
| 2007 | 1 |
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\" = 'MS' 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" = 'MS' 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 DFW07CA132Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Madison, MSThe pilot's failure to extend the landing gear prior to 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 MIA04LA102Accident · No injuriesLimited investigationFinal reportBeech V35B · Bay Saint Louis, MSThe failure of the pilot to verify the landing gear was extended prior to touchdown resulting in a gear-up landing.NTSB MIA04CA057Accident · No injuriesData collectionFinal reportBeech V35B · Bay St. Louis, MSThe failure of the pilot to complete the landing checklist and extend the landing gear resulting in a gear up landing and damage to the airplane.NTSB ATL04IA010Incident · No injuriesIncident investigationFinal reportBeech 58 · Columbus, MSThe pilot's failure to follow the pre-landing checklist, and his failure to extend the landing gear which resulted in a wheels up landing.NTSB MIA03CA117Accident · No injuriesData collectionFinal reportBeech 95-B55 · Forest, MSthe failure of the pilot-in-command to extend the landing gear, or use the checklist while on landing approach, resulting in a gear up landing.NTSB MIA02LA016Accident · No injuriesLimited investigationFinal reportCessna T310R · Madison, MSThe pilot's failure to verify that the landing gear was down and locked prior to landing resulting in the airplane being landed with the landing gear retracted.NTSB MIA99LA020Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Jackson, MSThe pilot's failure to ensure the landing gear was down resulting in a wheels up landing.NTSB ATL97LA131Accident · No injuriesLimited investigationFinal reportLearjet 31 · Aberdeen, MSThe flightcrew's failure to extend the landing gear.NTSB ATL97LA049Accident · No injuriesLimited investigationFinal reportCessna 441 · Madison, MSfailure of the pilot to follow the landing checklist, which resulted in a gear-up landing.