NTSB investigations, IA

10 cases where NTSB found Maintenance.

Cases per year

20102026
NTSB investigations, IA per year, 2010–2026: 10 cases
20101
20113
20152
20181
20201
20221
20231

Latest 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\" = 'IA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020620'))
  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 CEN24LA011Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Red Oak, IAThe fatigue failure of the exhaust valve due to excessive combustion deposits, which resulted in a partial loss of engine power. Contributing to the accident was the pilot’s failure to ensure that the required scheduled maintenance was completed.Oct 15, 2023 · N6JA · Substantial damageNTSB CEN22LA146Accident · Minor injuriesClass 3 · LimitedFinal reportHughes 369 · Adair, IAThe mechanic’s failure to properly torque a fuel control unit B-nut, which resulted in a partial loss of engine power, an attempted autorotation, and an impact with terrain.Mar 17, 2022 · N500MZ · Substantial damageNTSB CEN20LA276Accident · No injuriesClass 3 · LimitedFinal reportRockwell S2R R1340 · Keokuk, IAThe improper installation of a fuel vent line during maintenance, which resulted in fuel starvation and a total loss of engine power.Jul 12, 2020 · N3104S · Substantial damageNTSB CEN18LA278Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Vinton, IALoss of throttle control input due to a failure in the throttle control system. Contributing to the accident was the inadequate inspection and reinstallation of worn parts by maintenance personnel.Jul 17, 2018 · N5553X · Substantial damageNTSB CEN16LA032Accident · No injuriesLimited investigationFinal reportCessna 177RG · Red Oak, IAThe improper torque of the engine’s No. 3 cylinder intake pipe bolts, which resulted in the separation of the pipe and a partial loss of engine power.Oct 8, 2015 · N1542H · Substantial damageNTSB GAA15CA125Accident · No injuriesData collectionFinal reportCessna 180B · Waterloo, IAThe incorrect installation of the secondary seat stop reel which resulted in the pilot's loss of control when the seat moved full aft during takeoff.Jun 6, 2015 · N5067E · Substantial damageNTSB CEN11LA588Accident · Minor injuriesLimited investigationFinal reportHendryx Steve/Wiley Ross Super Rebel · La Porte City, IAThe improper assembly of the aileron cable by the airplane builder.Aug 21, 2011 · N540AF · Substantial damageNTSB CEN11LA367Accident · Minor injuriesLimited investigationFinal reportJones Cozy Mark IV · Sioux City, IAThe pilot's improper installation of the gascolator gasket during the airplane's last condition inspection, which resulted in a partial loss of engine power while maneuvering.May 30, 2011 · N204TJ · Substantial damageNTSB CEN11LA192Accident · No injuriesLimited investigationFinal reportBeech E-90 · Des Moines, IAThe improper installation of the right aileron by maintenance personnel.Feb 15, 2011 · N51DN · Substantial damageNTSB CEN10LA312Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Ankeny, IAThe failure of the stabilator control cable due to wear. Contributing to the accident was the inadequate maintenance inspection of the stabilator control cable.Jun 9, 2010 · N104NW · Substantial damage