NTSB investigations, 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, 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.\"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.
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" = 'NE' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA17CA508Accident · No injuriesData collectionFinal reportCessna 182 · North Platte, NEThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA482Accident · No injuriesData collectionFinal reportCessna 172 · Kearney, NEThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion.NTSB GAA17CA453Accident · No injuriesData collectionFinal reportPiper PA36 · McCook, NEThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while maneuvering downwind during an agricultural application flight, which resulted in an aerodynamic stall at low altitude.NTSB CEN17LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Pierce, NEThe pilot’s failure to maintain clearance from trees during a low-level agricultural aerial application flight.NTSB GAA17CA403Accident · No injuriesData collectionFinal reportLuscombe 8 · Grand Island, NEThe student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action.NTSB CEN17LA181Accident · 1 fatalLimited investigationFinal reportAS+ AC 4 · Blair, NEThe pilot's loss of control due to his diverted attention as he attempted to close the canopy that opened during initial climb.NTSB CEN17LA119Accident · No injuriesLimited investigationFinal reportMooney M20F · Hebron, NEA loss of directional control during landing for reasons that could be determined based on the available information.NTSB GAA17CA127Accident · No injuriesData collectionFinal reportVaughan Gerald R Side Winder TD · McCook, NEThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA16CA470Accident · No injuriesData collectionFinal reportCessna 182 · Diller, NEThe pilot's failure to go around after overshooting his intended touchdown point, which resulted in impact with farm equipment and terrain during an aborted landing attempt.NTSB CEN16LA352Accident · No injuriesLimited investigationFinal reportCameron Z90 · Morrill, NEThe pilot’s improper inflight fuel management, which resulted in fuel exhaustion and an inability to avoid contact with power lines.NTSB CEN16LA291Accident · 1 fatalLimited investigationFinal reportAir Tractor AT602 · David City, NEThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN16FA282Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Leshara, NEThe pilot's loss of airplane control during a practice stall maneuver, which resulted in a spin that continued to ground impact.NTSB GAA16CA355Accident · No injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Cairo, NEThe pilot's decision to fly into deteriorating weather conditions, leading to a precautionary off airport soft field landing which resulted in a nose gear collapse and the airplane to nose over.NTSB CEN16LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA 18-150 · Cozad, NEAn in-flight loss of control for reasons that could not be determined because examination of the wreckage did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB CEN16LA133Accident · Serious injuriesLimited investigationFinal reportMathieu Cassutt · Louisville, NEThe pilot's decision to operate with partial carburetor heat while operating in conditions conducive to the formation of carburetor ice, which resulted in a loss of engine power due to carburetor icing.NTSB CEN16FA130Accident · 1 fatalField investigationFinal reportAeronca 7AC · Ellsworth, NEThe pilot's impairment due to carbon monoxide poisoning from a known cracked engine exhaust muffler, which resulted in a loss of aircraft control. Contributing to the accident was the pilot's decision to continue flying the airplane without properly repairing…NTSB GAA16CA105Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415 · Chappell, NEThe pilot's inability to correct for a crosswind during the takeoff roll due to the interlinked flight control design, which resulted in a runway excursion, and a collision with terrain.NTSB CEN16FA073Accident · 1 fatalField investigationFinal reportCessna 172N · Wayne, NEThe noninstrument-rated pilot's improper decision to continue visual flight into instrument meteorological conditions, which resulted in a collision with terrain.NTSB GAA16CA063Accident · No injuriesData collectionFinal reportCessna 182D · Hamlet, NEThe student pilot's incorrect brake application which resulted in a runway excursion and a nose over.NTSB CEN16FA014Accident · 2 fatalField investigationFinal reportZidek Vans RV-4 · Cortland, NEThe pilot's decision to intentionally maneuver at a low altitude and his failure to maintain adequate airspeed during the climbing right turn, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN16FA005Accident · 1 fatalField investigationFinal reportBeech P35 · Chadron, NEThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into rising terrain during cruise flight.NTSB GAA15CA266Accident · Minor injuriesData collectionFinal reportSchweizer G 164B · Paxton, NEThe pilot's failure to maintain adequate distance from a power line during low altitude flight operations, which resulted in an impact with the power line, and subsequent impact with the ground.NTSB GAA15CA261Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Lexington, NEThe pilot's improper fuel planning which resulted in fuel exhaustion, and loss of engine power. Additionally, the pilot's failure to maintain pitch control during the emergency landing, which resulted in an aerodynamic stall.NTSB CEN15LA405Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Elmwood, NEThe pilot’s decision to take off with the airplane near its maximum gross weight from a runway that did not have sufficient length for the airplane to achieve a normal takeoff and positive climb rate after liftoff.NTSB CEN15LA389Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502B · Monroe, NELoss of propeller thrust for reasons that could not be determined, since examination of the airplane's engine, propeller, and associated accessories revealed no anomalies.NTSB OPS15IA020Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320 211 · Max, NEThe flight crew's continued flight into a closing gap between areas of thunderstorm activity and their failure to maintain the required lateral separation from the thunderstorms, which resulted in the airplane's encounter with hail and subsequent airplane…NTSB CEN15LA343Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Hartington, NEThe pilot’s decision to use an excessive, unapproved flap setting for takeoff, which significantly increased the induced drag and resulted in an aerodynamic stall when the airplane flew out of ground effect.NTSB CEN15LA271Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Foster, NEThe total loss of engine power during a low-level aerial application flight due to fuel exhaustion following the pilot’s inadequate preflight inspection that led to his assumption that sufficient fuel was on board for the flight based on his reliance on a…NTSB DCA15CA131Accident · Serious injuriesData collectionFinal reportBombardier CL600 2D24 · McCook, NEinadvertent encounter with turbulence while deviating around an area of known convective activity.NTSB CEN14CA514Accident · No injuriesData collectionFinal reportStanley Arthur Freeman Zodiac 601XL · Fremont, NEThe pilot's improper landing flare which resulted in a hard landing.NTSB CEN14CA403Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Allen, NEThe pilot did not ensure sufficient obstacle clearance for potential wind conditions, which resulted in his loss of control of the helicopter.NTSB CEN14CA429Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Minden, NEThe pilot's inadequate survey of the aerial application field which resulted in a collision with a windmill.NTSB CEN14LA390Accident · No injuriesLimited investigationFinal reportBell 206B · Bennet, NEA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to properly maintain the fuel storage tank.NTSB CEN14CA395Accident · No injuriesData collectionFinal reportCessna A188B · Milford, NEThe pilot's improper engine mixture setting which reduced available engine power, and his inadvertent retraction of flaps which resulted in an impact with crops and terrain.NTSB CEN14LA346Accident · 1 fatalLimited investigationFinal reportBuckeye Dream Machine · Ansley, NEThe powered parachute's reduced takeoff performance in tailwind conditions for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any preimpact anomalies that would have precluded normal…NTSB CEN14CA348Accident · Minor injuriesData collectionFinal reportZach Vans RV-6A · Wayne, NEThe pilot became distracted and landed short of the runway. Contributing to the accident was the hole in the ground.NTSB CEN14CA302Accident · No injuriesData collectionFinal reportCessna 180 · Springview, NEThe pilot's failure to maintain directional control of the airplane while landing in a crosswind. Contributing to the accident was the gusty crosswind.NTSB CEN14CA236Accident · No injuriesData collectionFinal reportMorris Thomas Lee Stolp Strdstr SA300 · Lincoln, NEThe pilot's loss of directional control while landing in gusty crosswinds in a tail wheel equipped airplane.NTSB CEN14CA137Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Gordon, NEA loss of engine power due to the pilot's improper planning and miscalculation of the fuel supply, which resulted in fuel exhaustion.NTSB CEN14LA131Accident · No injuriesLimited investigationFinal reportCessna R182 · Eustis, NEA catastrophic engine failure, which was initiated by the failure of the No. 5 connecting rod cap.NTSB CEN14CA063Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Burwell, NEAn inadvertent collision with a deer during landing.NTSB 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.NTSB 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.NTSB 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.NTSB CEN13CA530Accident · No injuriesData collectionFinal reportAeronca 7EC · Plattsmouth, NEThe pilot's loss of control during takeoff.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN13LA171Accident · No injuriesLimited investigationFinal reportPiper PA46 · Grand Island, NEThe pilot's failure to maintain airplane control after engine start.