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 CEN09CA429Accident · Minor injuriesData collectionFinal reportCessna A188B · Elwood, NEThe pilot's inability to maintain a climb after takeoff due to wind shift or downdraft.NTSB CEN09CA366Accident · Serious injuriesData collectionFinal reportSabre 2PL · Harrison, NEA loss of directional control for undetermined reasons.NTSB CEN09LA350Accident · 1 fatalLimited investigationFinal reportPeterson Allen L Dragonfly II · Arthur, NEThe pilot's continued visual flight into instrument meteorological conditions. Contributing to the accident was the pilot's impairment due to the use of a over-the-counter medication with sedative effects and spatial disorientation.NTSB CEN09CA328Accident · Serious injuriesData collectionFinal reportNational Ballooning 858 · Fremont, NEThe passenger’s inability to position herself properly for the normal balloon landing.NTSB CEN09CA289Accident · No injuriesData collectionFinal reportJihlavan KP · Crete, NEThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB CEN09LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A · Wood Lake, NEThe pilot's failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall.NTSB CEN09IA161Incident · No injuriesIncident investigationFinal reportPiper PA28 · Fairmont, NEBoth pilots' failure to see and avoid the other aircraft.NTSB CEN09CA072Accident · No injuriesData collectionFinal reportCessna 172I · Osh Kosh, NEThe pilot's failure to maintain control of the airplane while taxing in strong winds.NTSB CEN09CA050Accident · No injuriesData collectionFinal reportAeronca 7CCM · Chadron, NEThe pilot's failure to maintain direction control of the airplane. Contributing to the accident was the pilot's lack of experience.NTSB DEN08FA155Accident · 2 fatalField investigationFinal reportCessna 172L · York, NEThe student pilot's failure to maintain aircraft control, and the flight instructor's failure to take remedial action, for undetermined reasons.NTSB DEN08LA150Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Atkinson, NEThe total loss of engine power due to water contamination and corrosion within the fuel system at an undetermined time and from an undetermined source.NTSB DFW08CA189Accident · No injuriesData collectionFinal reportStinson 108-1 · Alliance, NEThe pilot's failure to maintain directional control on takeoff. Contributing to the accident was a lack of total experience.NTSB DEN08LA120Accident · Serious injuriesLimited investigationFinal reportChomo EAA Biplane B1 · Schuyler, NEThe pilot's failure to maintain clearance from the wire due to his diverted attention resulting in in-flight collision with the wire. Contributing to the accident was the pilot's failure to locate an emergency landing site.NTSB DFW08CA188Accident · No injuriesData collectionFinal reportBell 47G-3B · Mullen, NEThe plot's distraction with the chemical load resulting the failure to maintain control of the helicopter. A factor was no suitable terrain for landing.NTSB DEN08CA117Accident · No injuriesData collectionFinal reportCessna T182T · Omaha, NEThe pilot's improper use of the elevator trim resulting in a nose low/hard landing.NTSB DEN08FA100Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Gothenburg, NEThe pilot's failure to maintain aircraft control after encountering instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of Marihuana, his impaired judgement and decision making, and the low visibility weather…NTSB DFW08CA138Accident · No injuriesData collectionFinal reportJihlavan KP-5 · Norfolk, NEA hard landing as a result of the pilot's improper flare. A contributing factor was the prevailing wind.NTSB DFW08CA120Accident · No injuriesData collectionFinal reportHughes 269A · Lincoln, NEThe pilot's failure to properly execute a steep approach, which resulted in a tail strike and a loss of control.NTSB CHI08CA089Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Scribner, NEThe inadequate compensation for wind conditions and the directional control not obtained/maintained by the pilot during landing. A contributing factor was the crosswind.NTSB CHI08IA065Incident · No injuriesIncident investigationFinal reportBoeing 737-2H4 · Lincoln, NEThe improper installation of the swivel valve fittings by the operator's mechanic leading to the total loss of both hydraulic systems. Contributing to the incident were the swivel valves leaking and the total failure of the hydraulic system.NTSB CHI08CA043Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · Loop City, NEThe obstruction clearance not maintained by the pilot during an aerial application of a field and the subsequent hard landing onto the field. Contributing factors were the power line and rough/uneven terrain.NTSB CHI08CA025Accident · No injuriesData collectionFinal reportCessna 152 · O'Neill, NEThe pilot's failure to assure the oil filter was installed on the airplane which resulted in oil starvation. Factors associated with the accident were the mechanic not installing the oil filter, the low altitude at which the loss of engine power occurred, and…NTSB CHI07CA297Accident · No injuriesData collectionFinal reportBoeing Stearman E75 · Gordon, NEThe pilot's failure to maintain directional control during the crosswind landing which resulted in the inadvertent ground loop.NTSB CHI07CA292Accident · No injuriesData collectionFinal reportMaule M5-210C · Central City, NEThe pilot's improper compensation for the crosswind condition and his failure to maintain directional control during landing, which resulted in an inadvertent ground loop. A contributing factor was the crosswind.NTSB CHI07CA274Accident · No injuriesData collectionFinal reportCessna 140 · Grant, NEThe directional control not obtained/maintained by the pilot during landing. Contributing factors were the crosswind, gust, and ditch.NTSB CHI07CA251Accident · No injuriesData collectionFinal reportPiper PA-17 · Scribner, NEThe pilot's failure to maintain directional control during landing. A contributing factor was the gusting crosswind condition.NTSB CHI07CA223Accident · Minor injuriesData collectionFinal reportBush Caddy USA LSA · Chadron, NEThe pilot's failure to maintain control of the aircraft during landing. A contributing factor was the gusty, crosswind condition.NTSB CHI07LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-22-135 · Johnson, NEThe failure of the left wing's lift strut, which resulted in the separation of the left wing, and the subsequent airplane control not being possible. Factors were the overdue annual inspection, the overdue compliance with an Airworthiness Directive on the…NTSB CHI07CA166Accident · Serious injuriesData collectionFinal reportCessna A188B · Sargent, NEThe pilot's failure to maintain adequate visual lookout and clearance from the hillside. Factors contributing to the accident include the pilot's diverted attention, the hillside, and the glare from the setting sun.NTSB CHI07LA098Accident · 2 fatalLimited investigationFinal reportWakewood Lancair O-200 · Scottsbluff, NEThe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing to the accident were the low altitude at which the airplane was operating and the gusty wind conditions.NTSB CHI07FA068Accident · Serious injuriesField investigationFinal reportCessna 208B · Alliance, NEThe pilot's descent below minimum descent altitude while on a nonprecision approach. A contributing factor was a low ceiling.NTSB CHI06LA273Accident · Minor injuriesLimited investigationFinal reportDaub Pawnee Chief · McCook, NEThe failure of a welded joint at a cyclic control cable bracket located on the main rotor mast which made control of the helicopter impossible for the pilot.NTSB NYC06LA223Accident · Serious injuriesLimited investigationFinal reportBoeing 737-700 · Hastings, NEThe airplane's in flight encounter with thunderstorm related turbulence.NTSB CHI06LA255Accident · No injuriesLimited investigationFinal reportCessna A185E · Valentine, NEThe pilot's failure to maintain directional control of the airplane during the landing roll, resulting in an inadvertent ground loop by the pilot. A factor contributing to the accident was the gusting crosswind condition.NTSB CHI06CA254Accident · No injuriesData collectionFinal reportAir Tractor AT-400A · Alliance, NEThe pilot's inadequate preflight inspection which led to the aircraft tow bar not being removed prior to flight.NTSB DEN06LA112Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Harrisburg, NEThe loss of engine power resulting from mechanical failure of a connecting rod for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA235Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164A · Gering, NEThe pilot's failure to maintain clearance from the power lines during the aerial application flight. Factors were the low altitude and power lines.NTSB CHI06FA215Accident · No injuriesField investigationFinal reportManarin/Johnson Lancair IVP · Omaha, NEThe selection of an unsuitable landing area by the pilot of the other airplane, and his failure to maintain separation during landing.NTSB CHI06CA237Accident · No injuriesData collectionFinal reportSpittler Rans S-16 · Plattsmouth, NEA loss of engine power due to fuel starvation which resulted from a binding within the fuel servo. A factor associated with the accident was the high vegetation that was encountered during the forced landing.NTSB CHI06CA199Accident · Minor injuriesData collectionFinal reportPorter Mustang II · Ainsworth, NEThe delay in initiating the aborted landing which resulted in inadequate altitude to clear high vegetation off the end of the runway. Factors associated with the accident were the gusty crosswind, inadequate compensation for the wind conditions, and the high…NTSB CHI06CA169Accident · Serious injuriesData collectionFinal reportBeech 35-33 · Lincoln, NEA loss of engine power due to fuel exhaustion as a result of inaccurate fuel consumption calculations and inadequate monitoring of the remaining fuel quantity en route. A contributing factor was the inadequate supervision of the instructional flight by the…NTSB CHI06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-22-135 · Nebraska City, NEThe pilot's failure to maintain directional control during the landing rollout and the resulting ground loop. A contributing factor was the excessive tail wheel steering (rudder) input by the pilot.NTSB CHI06CA160Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Gretna, NEA run-on landing encountered by the pilot of the balloon due to the prevailing winds. The unfavorable winds were a contributing factor.NTSB CHI06CA143Accident · No injuriesData collectionFinal reportRobinson R44 · Stapleton, NEThe pilot not maintaining clearance fron the tree during landing. A factor was the tree.NTSB CHI06CA133Accident · Serious injuriesData collectionFinal reportCirrus Design SR22 · Verdigre, NEThe pilot's decision to land on a wet grass runway that had insufficient length available for landing roll. An additional cause was the pilot's failure to properly retract the flaps during the aborted landing, resulting in diminished climb performance and the…NTSB CHI06IA127Incident · Minor injuriesIncident investigationFinal reportCorporate Jets BAE125-800A · Lincoln, NEThe pilot-in-command's failure to maintain control during the initial roll at onset of the stall due to his improper remedial action related to the stall recovery. A contributing factor was initiation of an intentional stall with residual wing ice…NTSB CHI06LA099Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Omaha, NEAn inadvertent encounter with unforecast mountain wave turbulence during cruise flight. A contributing factor was the mountain wave (terrain induced) turbulence.NTSB CHI06LA071Accident · 1 fatalLimited investigationFinal reportVillarubia RV-6 · Decatur, NEAn inflight collision with the terrain for undetermined reasons.NTSB CHI06FA057Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · La Vista, NEThe non-instrument rated pilot not maintaining aircraft control and not maintaining altitude/clearance from terrain during takeoff into instrument meteorological conditions. Contributing factors were the low ceilings, night conditions present, and the pilot's…NTSB CHI06FA037Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Atlanta, NEThe non-instrument rated private pilot not maintaining clearance from the marked tower and his continued flight into adverse weather during cruise flight. Factors were the marked tower and the low ceilings present at the accident.