NTSB investigations, 2013

6 cases where NTSB found Miscellaneous.

Cases per year

20082026
NTSB investigations, 2013 per year, 2008–2026: 78 cases
20082
20098
20106
20115
20125
20136
20142
20159
20164
20173
20185
20192
20202
20214
20224
20233
20248

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\") = 2013
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0205'))
  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 ERA14FA027Accident · 1 fatalField investigationFinal reportCessna 172R · Nashville, TNThe noninstrument-rated pilot’s continued visual flight into night instrument flight rules conditions, which resulted in a collision with the runway during an attempted approach to land. Contributing to the accident was the pilot’s mental state, his…Oct 29, 2013 · C-GRJH · DestroyedNTSB ERA13FA330Accident · 1 fatalField investigationFinal reportCessna 172M · Fredericksburg, VAThe pilot's intentional descent into the ground to commit suicide.Jul 22, 2013 · N61954 · Substantial damageNTSB CEN13CA423Accident · No injuriesData collectionFinal reportBeech C23 · Augusta, KSThe pilot did not obtain adequate airspeed and clearance from obstructions during a grass field takeoff.Jul 20, 2013 · N377TT · Substantial damageNTSB CEN13LA384Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Heth, ARThe partial collapse of the right main landing gear during landing due to an improper previous weld repair to the right main landing gear and subsequent corrosion, which resulted in a loss of directional control and impact with terrain.Jun 28, 2013 · N455JM · Substantial damageNTSB WPR13LA203Accident · 1 fatalLimited investigationFinal reportHoffman RV-4 · Bullhead City, AZThe pilot’s suicidal act.Apr 20, 2013 · N194BD · Substantial damageNTSB ERA13FA101Accident · 3 fatalField investigationFinal reportPiper PA-30 · Jasper, ALThe student pilot’s poor judgment to take a multiengine airplane for which he did not have experience or permission to operate and depart into night instrument meteorological conditions, which resulted in a loss of airplane control and impact with terrain.Jan 2, 2013 · N7700Y · Destroyed