NTSB investigations, 2009
109 cases where the sequence of events included Landing gear collapse.
Cases, newest first
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\") = 2009
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '094' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2009 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '094' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA09LA209Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lumberton, MSCollapse of the landing gear due to worn left main landing gear components.NTSB CEN09CA184Accident · No injuriesData collectionFinal reportMarrero Andres Starduster · San Antonio, TXThe pilot's loss of control during take off. Contributing to the accident was the crosswind component.NTSB ANC09CA033Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the main landing gear collapsing during taxi.NTSB CEN09CA179Accident · No injuriesData collectionFinal reportAviat A-1C · Denver, COThe pilot's failure to maintain control during taxi. A contributing factor was the gusty winds.NTSB ANC09CA020Accident · No injuriesData collectionFinal reportBeech 65-A90-1 · Soldotna, AKThe pilot's misidentification of the runway surface during landing. Contributing to the accident were the snow-covered terrain, and low-light conditions.NTSB WPR09CA095Accident · No injuriesData collectionFinal reportDickson Vans RV-8 · El Monte, CAThe pilot's failure to maintain directional control during landing.NTSB CEN09CA139Accident · No injuriesData collectionFinal reportCessna 172I · Rockford, ILThe pilot's inability to maintain directional control during the landing roll after contacting a low-lying snow bank that was obscured by drifting snow.NTSB CEN09LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMCollapse of the landing gear during landing due to the incorrect installation of the landing gear actuator. Contributing to the accident was the pilot's failure to initiate the abnormal procedures checklist prior to landing.NTSB CEN09LA116Accident · Minor injuriesLimited investigationFinal reportLearjet 45XR · Telluride, COThe failure of both pilots to positively identify the runway prior to landing.