NTSB investigations
357 cases where NTSB found Aircraft handling/service.
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\", '0101')) 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", '0101')) 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 MIA08CA126Accident · Minor injuriesData collectionFinal reportTaylorcraft F19 · Montgomery, ALThe pilot's improper loading of personal belongings which resulted in rudder pedal interference.NTSB MIA08FA114Accident · No injuriesField investigationFinal reportBeech BE-58 · Jackson, MSAn outboard left wing explosion during takeoff due to the improper fuel cell installation and inadequate subsequent inspections by maintenance personnel.NTSB DFW08MA076Accident · 5 fatalClass 1 · MajorFinal reportCessna 500 · Oklahoma City, OKAirplane wing-structure damage sustained during impact with one or more large birds (American white pelicans), which resulted in a loss of control of the airplane.NTSB DEN08FA058Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Sterling, KSThe loss of pitch control during cruise flight resulting from the separation of the stabilator trim actuator due to inadequate maintenenace.NTSB DFW08TA066Accident · Minor injuriesFinal reportHughes OH-6 · Valentine, TXThe contract mechanic's failure to properly secure the castellated nut that attached the governor lever control rod to the idler bell crank. Contributing to the accident was the lack of maintenance oversight by the operator.NTSB NYC08CA089Accident · No injuriesData collectionFinal reportCessna 210G · Bessemer, ALThe pilot's failure to properly secure the airplane before attempting to hand-prop the engine.NTSB MIA08LA034Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Stevensville, MDA loss of engine power due to the failure of company maintenance personnel to comply with engine manufacturers requirements for carburetor adjustment during the 100-hour inspection.