NTSB investigations, 2013, NE

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026
NTSB investigations, 2013, NE per year, 1962–2026: 1,895 cases
19621
196458
196567
196672
196789
196880
196988
197074
197193
197264
197352
197471
197547
197664
197752
197849
197941
198036
198134
198242
198339
198440
198531
198627
198721
198816
198922
199013
199124
199220
199321
199420
199516
199614
199714
199828
199923
200013
200119
200214
200312
200411
200515
200617
200711
200813
200915
201013
20117
201221
201311
201411
201511
201610
20179
201812
201913
20209
20219
202214
202310
202417
202511
20264

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.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
  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 CEN14CA063Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Burwell, NEAn inadvertent collision with a deer during landing.Nov 18, 2013 · N30260 · Substantial damageNTSB CEN14LA053Accident · No injuriesLimited investigationFinal reportCessna 525A · Lincoln, NEThe airplane’s encounter with a flock of American White Pelicans, which resulted in one bird striking the right outboard wing during en route climb from the departure airport.Oct 12, 2013 · N368PK · Substantial damageNTSB CEN13CA545Accident · No injuriesData collectionFinal reportSwedener Rans S-6ES · Mullen, NEThe gopher holes and soft terrain the airplane encountered, which resulted in the airplane nosing over.Sep 10, 2013 · N611WE · Substantial damageNTSB CEN13CA538Accident · No injuriesData collectionFinal reportCessna 182J · Hyannis, NEThe pilot did not adequately compensate for the gusty wind conditions which resulted in a loss of directional control during the landing.Sep 7, 2013 · N3480F · Substantial damageNTSB CEN13CA530Accident · No injuriesData collectionFinal reportAeronca 7EC · Plattsmouth, NEThe pilot's loss of control during takeoff.Aug 31, 2013 · N4348C · Substantial damageNTSB CEN13FA429Accident · No injuriesField investigationFinal reportPiper PA-28R-201T · Holdrege, NEThe loss of engine power during takeoff due to the activation of the primer diverter valve.Jul 19, 2013 · N31698 · Substantial damageNTSB CEN13LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Campbell, NEThe pilot's decision to continue with the takeoff roll despite the airplane's difficulty becoming airborne The high-density altitude likely contributed to the airplane's reduced performance.Jun 23, 2013 · N6017E · Substantial damageNTSB CEN13LA340Accident · Serious injuriesLimited investigationFinal reportVans RV12 · Chadron, NEThe pilot’s failure to properly secure the latch to the tip-up canopy before flight, which resulted in the canopy opening on takeoff and a subsequent loss of airplane control while attempting to land the airplane.Jun 11, 2013 · N666BE · Substantial damageNTSB CEN13FA241Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Norfolk, NEThe pilot's decision to fly at a low altitude and his subsequent failure to see and avoid power lines.Apr 28, 2013 · N3970T · Substantial damageNTSB CEN13LA171Accident · No injuriesLimited investigationFinal reportPiper PA46 · Grand Island, NEThe pilot's failure to maintain airplane control after engine start.Feb 13, 2013 · N32CA · Substantial damageNTSB CEN13FA130Accident · 4 fatalField investigationFinal reportRaytheon 58 · Maxwell, NEThe pilot’s inadvertent encounter with severe icing conditions, which resulted in structural icing and the subsequent loss of airplane control.Jan 11, 2013 · N36VE · Destroyed