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.

NTSB ATL92LA130Accident · Minor injuriesLimited investigationFinal reportGrumman 164A · Abbeville, ALThe pilot's failure to see and avoid the top utility wire.Jun 25, 1992 · N5093 · DestroyedNTSB MIA92IA141Incident · No injuriesIncident investigationFinal reportCASA 212 · Mayaguez, PRFailure of the nosegear assembly steering actuator due to play at the lower trunnion, which caused a vibration, failure of the steering actuator, subsequent on ground loss of control, and on-ground collision with a sign during landing rollout.Jun 24, 1992 · N428CA · No damageNTSB LAX92LA261Accident · No injuriesLimited investigationFinal reportCessna 140 · Newhall, CAThe pilot's poor judgment and his overconfidence in his ability to fly his airplane.Jun 24, 1992 · N76962 · Substantial damageNTSB LAX92LA258Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Georgetown, CAThe under torque of the crankcase through bolts during overhaul causing; 1) the number 2 main bearing to spin, 2) the resultant blockage of the internal oil passage, and 3) the oil starvation induced failure of the number 2 connecting rod and cap. A factor in…Jun 24, 1992 · N9933N · Substantial damageNTSB LAX92FA260Accident · 3 fatalField investigationFinal reportCessna 421B · Monterey, CAThe owner/pilot's poor judgement in attempting an operation beyond his experience and ability, which resulted in his failure to attain an adequate climb profile necessary for terrain clearance. Also, the owner/pilot lacked instrument experience, and was…Jun 24, 1992 · N628RJ · DestroyedNTSB FTW92DPJ03Accident · 1 fatalFinal reportCessna 188A · Idabel, OKPower loss for undetermined reasons. A factor was lack of unsuitable terrain for the forced landing.Jun 24, 1992 · N9973G · DestroyedNTSB CHI92DTK03Accident · Serious injuriesFinal reportPiper PA-25-235/250 · Ramona, SDFailure of the pilot to maintain a visual lookout while maneuvering during aerial application of agricultural chemicals.Jun 24, 1992 · N4601Y · DestroyedNTSB CHI92DTG03Accident · No injuriesFinal reportGrumman G-164A · Orr, NDA stall encountered during the spray run reversal turn. Factors related to the accident are the attempted downwind turn, and insufficient altitude for recovery.Jun 24, 1992 · N9935 · Substantial damageNTSB SEA92LA133Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Blakely Island, WAThe pilot in command's not maintaining the proper rate of descent and not maintaining directional control, and separation of the nose gear strut and overload of the right main gear strut. Factors contributing to the accident were: weather conditions: tailwind…Jun 23, 1992 · N5794Q · Substantial damageNTSB SEA92LA132Accident · No injuriesLimited investigationFinal reportCessna 210D · Burley, IDThe pilot's inadequate visual lookout. Factors include FAA NOTAMS not being obtained, flight service station services not being used, and an object (temporary barrier) on the runway.Jun 23, 1992 · N3739Y · Substantial damageNTSB SEA92LA131Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Corbett, ORThe failure of the float attach fitting, and the separation of the floats from the aircraft.Jun 23, 1992 · N6470M · Substantial damageNTSB NYC92LA126Accident · Serious injuriesLimited investigationFinal reportSchweizer 1-26E · Waynesboro, VAThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall while on approach. Factors related to the accident were: the pilot's lack of experience, an improperly planned approach, and the gusty winds.Jun 23, 1992 · N2781H · Substantial damageNTSB LAX92LA259Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe failure of the pilot to maintain an adequate wing tip clearance between the aircraft and a dirt bank paralleling the airstrip.Jun 23, 1992 · N48658 · Substantial damageNTSB LAX92FA257Accident · 2 fatalField investigationFinal reportWaco UPF-7 · Sedona, AZFuel exhaustion due to the pilots inadequate preflight planning and his failure to refuel the airplane prior to departure. Factors in the accident were: 1) the unreliable fuel sight gauges which were contaminated with a tar like residue which may have…Jun 23, 1992 · N29926 · DestroyedNTSB CHI92DCQ04Accident · Minor injuriesFinal reportWSK PZL Mielec M18 · Norton, KSFailure of the pilot in command to level off while performing aerial application.Jun 23, 1992 · N90135 · Substantial damageNTSB SEA92IA136Incident · No injuriesIncident investigationFinal reportFokker F.28 MK 1000 · Portland, ORThe partial failure of the horizontal stabilizer trim drive system, the restricted movement of the stabilizer, and the overtorque of a system component.Jun 22, 1992 · CGTAH · No damageNTSB NYC92LA124Accident · No injuriesLimited investigationFinal reportCessna 421B · Columbus, OHThe electrical fire which started in a component that was part of a door seal modification. Also causal to the accident was the installation of this unapproved airplane modification.Jun 22, 1992 · N39PW · Substantial damageNTSB LAX92LA256Accident · No injuriesLimited investigationFinal reportLake 200 · Clearlake, CAThe pilot's inadequate weather evaluation of the wind on the Lake and his delay in lift-off. Contributing to the accident was the rough water that existed on the unsheltered section of the Lake.Jun 22, 1992 · N67C · Substantial damageNTSB NYC92FA123Accident · 1 fatalField investigationFinal reportMBB BK-117 · Middletown, CTA wire strike after the pilot made a decision to continue the approach into an area of hazards. Factors related to the accident were the failure of the pilot and the hospital communicator to request all available information about the landing area and…Jun 21, 1992 · N117HH · DestroyedNTSB LAX92LA262Accident · Serious injuriesLimited investigationFinal reportBell 47-G5A · Pago Pago (Pacific Ocean)The pilot's inadequate preflight inspection in failing to ensure that all skid tiedowns were removed prior to the attempted takeoff.Jun 21, 1992 · N211CB · Substantial damageNTSB FTW92LA166Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ponca City, OKThe pilot's failure to maintain main rotor RPM. A factor was the contaminated fuel.Jun 21, 1992 · N66LR · Substantial damageNTSB CHI92LA187Accident · No injuriesLimited investigationFinal reportBeech M35 · Dekalb, ILThe pilot's failure to use proper nose wheel steering which resulted in a loss of directional control.Jun 21, 1992 · N9873R · Substantial damageNTSB CHI92LA185Accident · No injuriesLimited investigationFinal reportCessna 150H · Three Rivers, MIThe pilot-in-command's selection of a rough and uneven terrain. A factor related to the accident was the pilot-in-command's poor inflight decision making.Jun 21, 1992 · N22120 · Substantial damageNTSB ATL92LA129Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Donalsonville, GAThe pilot's inadequate preflight inspection of the aircraft, and his failure to detect water in the aircraft fuel system.Jun 21, 1992 · N10273 · Substantial damageNTSB ATL92LA128Accident · Minor injuriesLimited investigationFinal reportBoeing D75N1 · Stockbridge, GAThe improper compensation for the downwind condition by the pilot in command. A factor in the accident was the improper in flight planning to attempt a downwind landing on the short runway with rising terrain by the pilot in command.Jun 21, 1992 · N53232 · Substantial damageNTSB ANC92LA098Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kantishna, AKThe pilot in command's excessive taxi speed. Factors relating to the accident were the crosswind and dusk light conditions.Jun 21, 1992 · N7850H · Substantial damageNTSB ANC92LA096Accident · No injuriesLimited investigationFinal reportCessna 185 · Sole Lake, AKThe pilot in command's inadequate compensation for the wind conditions. Factor was the unfavorable wind.Jun 21, 1992 · N1589F · Substantial damageNTSB SEA92FA130Accident · 1 fatalField investigationFinal reportChampion 7GCBC · Prosser, WAInadequate inflight planning/preparation and airspeed was not maintained. A factor to the accident was: an uncontrolled stall/spin.Jun 20, 1992 · N1812G · Substantial damageNTSB NYC92LA122Accident · Serious injuriesLimited investigationFinal reportVictor E. Nigro KR-2 · Lebanon, PAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and uncontrolled descent to the ground. Factor related to the accident were the pilot's lack of expereince in the type of airplane and the partial loss of engine power.Jun 20, 1992 · N21144 · DestroyedNTSB FTW92LA167Accident · No injuriesLimited investigationFinal reportGlasflugel 201B · Briggs, TXThe inadvertent ground loop by the pilot. Factors were the downdraft and the rough/uneven terrain.Jun 20, 1992 · N6152 · Substantial damageNTSB FTW92FA165Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Addison, TXFailure of the left elevator assembly due to corrosion.Jun 20, 1992 · N3128M · Substantial damageNTSB FTW92DRA03Accident · No injuriesFinal reportSchweizer G-164B · Bay City, TXThe pilot's inability to initiate a climb due to exceeding the takeoff capability of the airplane. A factor was the high grass on the airstrip.Jun 20, 1992 · N8157K · Substantial damageNTSB DEN92LA063Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Brighton, COThe pilot's inadequate visual lookout.Jun 20, 1992 · N81229 · 2 aircraft · Substantial damageNTSB DEN92LA062Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Rocky Ford, COThe pilots failure to maintain altitude due to spatial disorientation. Factors were: low overcast skies and ground fog.Jun 20, 1992 · N3649D · DestroyedNTSB ATL92LA127Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Dunn, NCThe pilot's inadequare visual lookout to see and avoid the 8 foot high pole adjacent to the landing strip.Jun 20, 1992 · N55464 · Substantial damageNTSB NYC92LA121Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Bedford, NHPhysical impairment of the pilot as the result of alcohol consumption, resulting in his failure or inability to maintain control of the airplane. Factors which contributed to the accident were: the pilot's poor judgement in buzzing residences and his failure…Jun 19, 1992 · N8736V · Substantial damageNTSB NYC92LA120Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Huron, OHThe student pilot's alcoholic impairment of efficiency and judgement which led to his geographical disorientation and eventual fuel exhaustion and total loss of engine power, and his failure to maintain airspeed during the forced landing resulting in a…Jun 19, 1992 · N8215S · DestroyedNTSB NYC92DGM02Accident · No injuriesFinal reportPeres 5151 · Erie, PASeizure of the #2 piston which resulted in the lost of engine power and subsequent collision with trees during a forced landing.Jun 19, 1992 · N5151M · Substantial damageNTSB MIA92WA140Accident · Minor injuriesForeign investigationPiper PA-23-250 · Rock Sound, BahamasJun 19, 1992 · N40460 · Substantial damageNTSB LAX92TL#10Accident · No injuriesClass 3Final reportGrumman TS2F · Columbia, CAJun 19, 1992 · N427DE · DestroyedNTSB LAX92LA255Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Window Rock, AZThe failure of the pilot to calculate the aircraft's performance data and perform a weather evauluation. The existing high density altitude was a factor in the accident.Jun 19, 1992 · N589C · Substantial damageNTSB LAX92LA254Accident · Minor injuriesLimited investigationFinal reportBell 206-L3 · Waikoloa, HIFailure of the rear landing gear cross tube due to corrosion.Jun 19, 1992 · N2267N · Substantial damageNTSB LAX92LA253Accident · No injuriesLimited investigationFinal reportPiper PA-60-700P · Coalinga, CAThe pilot's failure to attain the proper touchdown point and misjudging the aircraft's distance from the runway. Contributing to this accident was the crosswind condition and the nose and main landing gear collapsing due to overload.Jun 19, 1992 · N626NP · Substantial damageNTSB FTW92LA173Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Bryan, TXThe certified flight instructor's misjudging the runway remaining for the aborted landing. Factors were the student pilot's misjudging the touchdown point and inadequate supervision of the approach by the CFI.Jun 19, 1992 · N24611 · Substantial damageNTSB DEN92LA061Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Falcon, COInadvertent stall during initial climb following takeoff.Jun 19, 1992 · N9151K · Substantial damageNTSB DCA92MA040Accident · 10 fatalMajor investigationFinal reportCessna 402C · Meadview, AZFailure of the pilot to follow the emergency procedure (engine failure after takeoff) and his failure to maintain minimum control speed (VMC), which resulted in a loss of aircraft control. Factors related to the accident were failure (disengagement) of the…Jun 19, 1992 · N2715X · DestroyedNTSB CHI92DCQ03Accident · No injuriesFinal reportCessna A188B · Meade, KSThe pilot's improper preflight planning/preparation and his exceeding the aircraft's takeoff capability.Jun 19, 1992 · N4813R · Substantial damageNTSB ANC92LA095Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKEngine failure due to total oil loss. Contributing to the accident were the separation of the oil filter adapter from the oil pump due to improper maintenance procedures and non adherence to recommended directives by company maintenance personnel, and the…Jun 19, 1992 · N23CF · Substantial damageNTSB SEA92LA129Accident · 1 fatalLimited investigationFinal reportWilliam Bovard Glasair · Woodland, WAInadequate airspeed. Factors to the accident were: a tailwind takeoff and poor preflight planning/preparation.Jun 18, 1992 · N107WB · DestroyedNTSB FTW92LA168Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA-326 · Clifton, TXThe inadvertent stall by the pilot. Factors were the inadequate altitude and the pilot's lack of experience in type aircraft.Jun 18, 1992 · N71528 · Substantial damage