NTSB investigations, 2016

5 cases where NTSB found Maintenance/inspections, general.

Cases per year

20082026
NTSB investigations, 2016 per year, 2008–2026: 103 cases
20084
200910
20109
20119
20125
20137
201410
201515
20165
20175
20184
20194
20201
20213
20224
20234
20244

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 year(c.\"eventDate\") = 2016
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01010500'))
  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 CEN17LA019Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31A · Mc Alester, OKA total loss of engine power during initial climb due to fuel starvation.Oct 16, 2016 · N93668 · Substantial damageNTSB CEN17LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Jasper, TXA partial loss of engine power for reasons that could not be determined, because an examination of the airplane did not identify a specific reason for the loss of engine power.Oct 15, 2016 · N9473D · Substantial damageNTSB CEN16LA339Accident · Serious injuriesLimited investigationFinal reportRans Coyote S 4 · Clarksville, TXThe total loss of engine power due to a deteriorated and disconnected fuel line, which resulted in fuel starvation and a subsequent hard, off-field landing.Aug 27, 2016 · N8024J · Substantial damageNTSB WPR16LA141Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Minden, NVThe failure of a main landing gear leg during takeoff due to corrosion, which resulted in a nose-over during the subsequent landing on a grassy area.Jul 17, 2016 · N2759K · Substantial damageNTSB ERA16LA202Accident · Minor injuriesLimited investigationFinal reportBell 407 · Mountain City, TNAn incorrect and unapproved repair of the engine compressor diffuser performed by a machinist at a repair facility, which resulted in failure of the compressor diffuser aft plate and a partial loss of engine power.Jun 3, 2016 · N4999 · Substantial damage