NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 NYC05LA038Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-82 · Providence, RIThe vehicle driver's failure to maintain directional control, which resulted in a collision with the airplane during push-back. A factor was the icy ramp area.NTSB CHI05LA047Accident · No injuriesLimited investigationFinal reportLearjet 25B · Cedar Rapids, IAThe pilot was not able to maintain directional control of the airplane due to the failure of the nose gear strut seal which prevented the nose wheel from centering. A factor associated with the accident was the berm that the airplane contacted.NTSB LAX05LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jean, NVthe pilot's inadequate in-flight planning/decision and failure to divert to an alternate airport in a more timely manner, which resulted in fuel exhaustion and a loss of engine power. A factor in the accident was an inaccurate fuel gauge.NTSB LAX05FA054Accident · 2 fatalField investigationFinal reportCessna 182P · La Mirada, CAthe pilot's inadequate visual lookout and failure to maintain altitude/clearance from a transmission tower while on an extended base leg of the traffic pattern. A factor in the accident was the sun glare condition.NTSB IAD05CA025Accident · Minor injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Wheeling, WVThe pilot misjudged his distance/speed, and his intentional landing on an unsuitable taxiway at night. A factor in the accident was the night light conditions.NTSB DFW05LA041Accident · Serious injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Texas City, TXThe pilot's failure to maintain clearance with terrain while performing aerobatics at a low altitude.NTSB DEN05LA042Accident · No injuriesLimited investigationFinal reportRobinson R22 · Park City, UTthe student pilot's failure to maintain aircraft control, and the instructor's inadequate supervision by her failure to assure adequate rotor rpm was maintained.NTSB DEN05LA039Accident · No injuriesLimited investigationFinal reportRaytheon C90A · Salt Lake City, UTthe pilot's failure to obtain/maintain a proper climb rate and the pilot's premature initiation of the turn (low altitude flight maneuver). Contributing factors include the pilot's improper in-flight planning and decision making, the low altitude, the fog,…NTSB DEN05CA040Accident · No injuriesData collectionFinal reportDaniels Vans RV-8 · Albuquerque, NMthe pilot's failure to maintain directional control resulting in a ground loop.NTSB SEA05CA027Accident · Minor injuriesData collectionFinal reportBreit Zodiac (CH-601-HDS) · Everett, WAThe pilot's failure to maintain aircraft control immediately after takeoff. A factor was the wake turbulence from the preceding airplane.NTSB NYC05CA035Accident · Minor injuriesData collectionFinal reportRaytheon Corporate Jets 400A · Cleveland, OHThe loss of directional control by the operator of a ground service vehicle.NTSB DEN05LA041Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Steamboat Spngs, COthe loss of engine power due to carburetor icing. Contributing factors include the conditions conducive for carburetor icing, the lack of suitable terrain for a forced landing, the inadequate preflight planning and decision making and the fence.NTSB MIA05LA043Accident · No injuriesLimited investigationFinal reportCessna 172S · Lakeland, FLThe faulure of the pilot to maintain directional control of the aircraft during the landing roll resulting in the on-ground collision with a taxiway sign and subsequent collapse of the nose landing gear.NTSB LAX05LA083Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Dev. CH-2000 · Jean, NVan in-flight separation of the left cockpit door due to the failure of the hinges from repeated exposure to wind or propeller slip stream forces while in the open position. The hinge failures were the ultimate result of the failure of persons unknown to…NTSB DFW05LA043Accident · 1 fatalLimited investigationFinal reportAkers Douglas RA40 Defiant · Slaton, TXThe pilot's failure to maintain aircraft control. Contributing factors were the opening of the canopy in-flight and the pilot's diverted attention.NTSB DFW05FA040Accident · 1 fatalField investigationFinal reportBell 407 · Ship Shoal 130EThe pilot's failure to maintain clearance with a stationary object while maneuvering for landing. Contributing factors were the inadequate facilities available for landing, the pilot's lack of information regarding the landing area, and the operational status…NTSB DFW05CA042Accident · Minor injuriesData collectionFinal reportOhlemeier/Stratton RV-7A · Gordonville, TXThe pilot's misjudged flare. Contributing factors were the uphill slope of the runway and the soft condition of the landing area.NTSB DEN05FA038Accident · 3 fatalField investigationFinal reportCessna 421 · Englewood, COloss of engine power due to fuel starvation, and the instructor's failure to maintain aircraft control. Contributing factors were a partially blocked fuel line resulting in restricted fuel flow, the instructor's failure to perform critical emergency…NTSB DCA05WA019Accident · Serious injuriesForeign investigationShort Brothers SD3-60 · Ontario, CanadaNTSB ATL05LA035Accident · No injuriesLimited investigationFinal reportBell UH-1H · Rockford, ALThe pilot's failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tree.NTSB ANC05CA017Accident · No injuriesData collectionFinal reportCessna U206G · Nunapitchuk, AKThe pilot's inadequate compensation for gusty wind conditions, which resulted in a loss of directional control, and collision with a ditch. Factors contributing to the accident were an icy taxiway and wind gusts.NTSB LAX05FA053Accident · 1 fatalField investigationFinal reportEurocopter AS-350-B3 · Apache Junction, AZA loss of control during the final approach to land for undetermined reasons.NTSB DEN05LA036Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Provo, UTthe flight instructor's failure to maintain clearance from the water. Contributing to the accident was the flight instructor's inability to detect a descent because of the obscuration between the water and the horizon due to the gray skyNTSB ANC05LA068Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Utopia, AKThe pilot's misjudged distance/speed while on final approach to land, which resulted in an overrun during the landing roll. Factors associated with the accident are the pilot's inadequate weather evaluation, and a gusty tailwind.NTSB DFW05WA039Accident · 5 fatalForeign investigationAero Commander AC-685 · Apodaca, MexicoNTSB DFW05FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Abita Springs, LAThe loss of engine power for undetermined reasons. Also causal was the pilot's improper in-flight emergency planning when he misjudged his available altitude and made a 360 degree turn away from the airport instead of proceeding directly to it, which resulted…NTSB DCA05WA022Incident · No injuriesForeign investigationBoeing 747-200 · Incheon, South KoreaNTSB CHI05LA045Accident · No injuriesLimited investigationFinal reportPilatus PC-12/45 · South Bend, INFailure of the fuel control unit (FCU) bellows which resulted in a significant loss of engine power and the pilot's encounter with unsuitable terrain during the subsequent forced landing. A contributing factor was the pilot's inadvertent exceedence of the…NTSB ANC05LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Sleetmute, AKA loss of engine power during cruise flight due to a fractured exhaust valve, which resulted in a forced landing, and subsequent nose over of the airplane. A factor associated with the accident was the lack of suitable terrain for a successful emergency…NTSB LAX05CA052Accident · No injuriesData collectionFinal reportClassic Waco YMF · Santa Barbara, CAThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during landing rollout, which resulted in a ground loop.NTSB DFW05LA037Accident · 2 fatalLimited investigationFinal reportCrosley Christen Eagle II · Morris, OKThe pilot's intentional spin, which was unrecoverable due to exceeded aircraft weight and balance limitations as a result of improper preflight planning/preparation.NTSB DEN05LA035Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Monte Vista, COthe pilot's failure to maintain adequate airspeed which resulted in a stall during low level flight.NTSB DCA05WA020Incident · No injuriesForeign investigationBoeing 747 · London, United KingdomNTSB LAX05LA050Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Ontario, CAa loss of engine power due to the Designated Pilot Examiner's failure to follow the flight manual procedures and directives regarding throttle settings to be used for practice autorotations.NTSB LAX05LA049Accident · No injuriesLimited investigationFinal reportRobinson R22B · Los Angeles, CAThe activation of the low main rotor rpm warning system for undetermined reasons.NTSB DEN05FA034Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-60 · Englewood, COthe pilot's failure to maintain minimum controllable airspeed during the night visual approach resulting in a loss of control and uncontrolled descent into terrain. A contributing factor was the precautionary shutdown of the left engine for undetermined…NTSB DFW05WA035Accident · 2 fatalForeign investigationBeech BE-36-TC · Pereira, ColombiaNTSB DFW05LA034Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Bay View, TXThe pilot's failure to maintain directional control as result of his improper runway selection for takeoff. A contributing factor was the prevailing right quartering tailwind.NTSB CHI05CA043Accident · No injuriesData collectionFinal reportBellanca 14-19 · Williston, NDThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A contributing factorwas the approach light.NTSB DFW05LA033Accident · No injuriesLimited investigationFinal reportMooney M20F · Fabens, TXThe loss of engine power as a result of the failure of a connecting rod due to oil starvation/exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA031Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Tulsa, OKThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and in-flight planning / preparation.NTSB DFW05FA032Accident · Serious injuriesField investigationFinal reportHughes 369D · Zachary, LAThe loss of engine power as a result of fatigue cracking of the compressor adaptor coupling initiated by fretting on the pilot diameter and subsequent disconnection of the compressor from the turbine assembly. A contributing factor was the low operating…NTSB DFW05CA044Accident · No injuriesData collectionFinal reportBell B206L-1 · Patterson, LAThe loss of engine power due to fuel starvation resulting from the pilot's failure to activate the fuel boost pumps prior to takeoff. A contributing factor was that the helicopter was at an airspeed and altiutude combination (below height/velocity curve)…NTSB CHI05FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Glenwood, MNThe pilot's failure to execute a missed approach and his failure to maintain sufficient altitude and clearance from terrain and obstructions. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his decision to delay descent…NTSB ATL05FA034Accident · 3 fatalField investigationFinal reportDiamond DA40-180 · Pelzer, SCThe pilot's failure to follow IFR procedures and to maintain assigned altitude resulting in a collision with a transmission wire and trees.NTSB NYC05LA030Accident · No injuriesLimited investigationFinal reportDay VP-2 · Warrenton, VAA loss of engine power for an undetermined reason.NTSB LAX05FA046Accident · 1 fatalField investigationFinal reportCessna T207A · Meadview, AZa loss of control due to the in-flight separation of the right elevator and elevator trim tab control surfaces. The precipitating reason for the elevator separation could not be resolved as related to the tab foam core issue with the available evidence.NTSB LAX05FA045Accident · 1 fatalField investigationFinal reportCessna T310R · Flagstaff, AZThe pilot's decision to attempt flight into known adverse weather conditions beyond the capability of the airplane and his failure to ensure that the airplane's wings were free of ice and/or snow contamination that accumulated while the airplane was on the…NTSB LAX05CA047Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Kapolei, HIthe pilot's failure to maintain directional control, which resulted in a collision with an obstacle.NTSB LAX05CA044Accident · Minor injuriesData collectionFinal reportCessna 150J · Amado, AZthe pilot's inaccurate fuel consumption calculations and failure to refuel the airplane at the intermediate stop, which resulted in fuel exhaustion.