NTSB investigations

206 cases where NTSB found Maintenance/inspections.

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\", '010105'))
  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.

NTSB DFW08LA223Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Uvalde, TXA total loss of engine power due to the improper use of unauthorized replacement parts in the engine and repeated operation of the engine in an over-temperature condition.Sep 1, 2008 · N8472V · Substantial damageNTSB DFW08LA196Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Petersburg, TXA partial loss of engine power due to the substandard and incomplete maintenance of the engine.Jul 21, 2008 · N57601 · Substantial damageNTSB 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.Jun 5, 2008 · N3106W · Substantial damageNTSB 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.Feb 13, 2008 · N62793 · DestroyedNTSB 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.Feb 8, 2008 · N66372 · Substantial damageNTSB 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.Jan 3, 2008 · N26WR · Substantial damage