NTSB investigations
57 cases where NTSB found Conditions/weather/phenomena, general.
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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030300')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030300')) 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 CEN09LA541Accident · Serious injuriesLimited investigationFinal reportCessna CE-560 · Kremmling, COThe lineman’s inadvertent encounter with jet blast.NTSB WPR09CA344Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26A · Lake Riverside, CAA loss of lift which necessitated a forced landing in a field.NTSB CEN09CA397Accident · No injuriesData collectionFinal reportWeatherhead Peter L Stol CH 701 · Hayward, WIThe pilot's improper flare resulting in a hard landing during gusty wind conditions. Contributing to the accident was the pilot's lack of experience with the accident airplane.NTSB DCA09MA027Accident · 50 fatalClass 1 · MajorFinal reportBombardier DHC-8-402 · Clarence Center, NYThe captain’s inappropriate response to the activation of the stick shaker, which led to an aerodynamic stall from which the airplane did not recover. Contributing to the accident were (1) the flight crew's failure to monitor airspeed in relation to the…NTSB LAX08LA283Accident · No injuriesLimited investigationFinal reportCessna 172 · Honolulu, HIThe flight's encounter with the jet wash from a parked commercial airplane while taxiing for takeoff.NTSB DEN08FA092Accident · 1 fatalField investigationFinal reportMcDonnell Douglas Helicopter C MD 500E · Sunrise Beach, MOThe loss of tail rotor effectiveness and the pilot's failure to regain aircraft control. Contributing to the accident was the pilot's decision to fly in known adverse weather conditions and the gusty winds generated from convective outflow. Contributing to…NTSB DFW08CA112Accident · Minor injuriesData collectionFinal reportHaecker Spacewalker · Kingsbury, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.