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 LAX90TL004Accident · No injuriesClass 3Final reportNorth American F-86E · Okinawa, JapanOn June 5, 1990, at about 1300 local time, a Canadair F-86E (mk.6), N93FS, owned by tractor flight system, inc of santa ana, California and operated by the U.S. Air force, was involved in an accident and was destroyed during a public use, instructional…Jun 5, 1990 · N93FS · DestroyedNTSB FTW90DRD11Accident · No injuriesFinal reportBell 47G3-B · Houma, LAThe pilot's failure to maintain rotor RPM and an excessive sink rate.Jun 5, 1990 · N73241 · Substantial damageNTSB DEN90LA132Accident · No injuriesLimited investigationFinal reportLund Mustang II · Hamilton, MTThe inadequate compensation for the wind conditions by the pilot.Jun 5, 1990 · N81BL · Substantial damageNTSB MKC90LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcpherson, KSPoor pre-flight and in-flight planning and refueling not performed by the pilot in command.Jun 4, 1990 · N48642 · Substantial damageNTSB MIA90LA138Accident · Minor injuriesLimited investigationFinal reportSpezio Sport DAL-1 · Columbus, MSFailure of the pilot to maintain adequate airspeed, resulting in an inadvertent stall and subsequent loss of control. A related factor was: the lack of a stall warning system installed in the aircraft.Jun 4, 1990 · N20LW · Substantial damageNTSB LAX90LA208Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Truckee, CAThe pilot's improper decision to release from the tow airplane at an insufficient altitude on the lee side of the mountains.Jun 4, 1990 · N2423W · Substantial damageNTSB LAX90LA207Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Colusa, CAThe pilot's failure to maintain directional control during touchdown.Jun 4, 1990 · N21Y · Substantial damageNTSB FTW90DRD10Accident · No injuriesFinal reportGrumman G-164B · Mamou, LAPilot misjudged wind information. Factors contributing to the accident were the tailwind, the trees and the levee.Jun 4, 1990 · N6693Q · Substantial damageNTSB FTW90DPA04Accident · No injuriesFinal reportBoeing A75N1 · Longview, TXThe pilot's abrupt use of the wheel brakes during the landing roll.Jun 4, 1990 · N27933 · Substantial damageNTSB DEN90LA125Accident · No injuriesLimited investigationFinal reportCessna 188A · Martin, SDThe on-ground loss of control during the takeoff ground run. Contributing to this accident was the pilot's failure to use optimum takeoff flaps for the runway conditions that existed, and the soft wet runway surface.Jun 4, 1990 · N78516 · Substantial damageNTSB DEN90LA124Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Sturgis, SDPilot inadvertently stalling the airplane. Contributing to the accident was the pilot's lack of total experience.Jun 4, 1990 · N6418F · DestroyedNTSB DEN90LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Douglas, WYThe accident to be improper installation of aileron control system by maintenance personnel, and failure to perform an aircraft preflight by the pilot in command.Jun 4, 1990 · N4720A · Substantial damageNTSB CHI90DEC02Accident · Minor injuriesFinal reportSchweizer G-164C · Sandusky, MIThe pilot's failure to maintain adequate airspeed during the swath run turn.Jun 4, 1990 · N8095K · DestroyedNTSB BFO90FA054Accident · 2 fatalField investigationFinal reportCessna 172RG · Onego, WVVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain adequate clearance (altitude) from mountainous terrain. The terrain and adverse weather conditions were related factors.Jun 4, 1990 · N5117U · DestroyedNTSB SEA90FA091Accident · 1 fatalField investigationFinal reportCessna 172K · Tacoma, WAThe pilot did not adequately maintain a proper glide path for landing which resulted in an inflight collision with a tree.Jun 3, 1990 · N79931 · DestroyedNTSB MIA90LA137Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe improper landing flare by the pilot in command.Jun 3, 1990 · N95733 · Substantial damageNTSB FTW90LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student pilot misjudged the flare to land.Jun 3, 1990 · N714TT · Substantial damageNTSB FTW90LA113Accident · No injuriesLimited investigationFinal reportLuscombe 11 · Fort Worth, TXLoss of control on the ground, due to a locked left brake, undetermined reasons.Jun 3, 1990 · N1615B · Substantial damageNTSB FTW90DPJ07Accident · Minor injuriesFinal reportCessna T188C · Altus, OKThe PIC did not maintain the proper clearance from the powerline.Jun 3, 1990 · N4680J · DestroyedNTSB DEN90LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Belgrade, MTThe inadvertent stall experienced during the attempted forced landing.Jun 3, 1990 · N9375T · DestroyedNTSB DEN90FA120Accident · 1 fatalField investigationFinal reportCessna 170A · Dillon, COImproper planning/decision by the pilot, and his failure to maintain airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the high density altitude and terrain conditions.Jun 3, 1990 · N3944V · Substantial damageNTSB CHI90LA149Accident · No injuriesLimited investigationFinal reportBeech F33A · Port Clinton, OHThe pilot failed to maintain aircraft control after encountering gusty wind conditions during the takeoff roll.Jun 3, 1990 · N1847W · Substantial damageNTSB CHI90FA146Accident · 4 fatalField investigationFinal reportBeech A36 · Gaylord, MIThe pilot's inadequate airspeed, while maneuvering (turning) after takeoff, which resulted in a stall/mush. Factors related to the accident were: the pilot's improper planning/decision, failure to maintain weight and balance limits, and adverse wind…Jun 3, 1990 · N3671B · DestroyedNTSB CHI90DEV05Accident · Minor injuriesFinal reportCessna 172P · Jerseyville, ILThe pilot's failure to go around when crosswinds upset aircraft alignment with the runway in the flare. Contributing to the accident was the pilot's attempt to land in crosswinds which exceeded the maximum for which the model has been demonstrated capable.Jun 3, 1990 · N64085 · Substantial damageNTSB ATL90DKG04Accident · No injuriesFinal reportAir Command 532 · Rome, GAThe pilot attempted a flat spiraling spin maneuver at an altitude that was too low to effect a safe recovery.Jun 3, 1990 · N2173B · Substantial damageNTSB SEA90LA092Accident · No injuriesLimited investigationFinal reportCessna 182A · Tekoa, WAThe pilot turned off the carburetor heat while descending for landing in conditions conducive to carburetor icing.Jun 2, 1990 · N4944D · Substantial damageNTSB NYC90LA124Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Barre, MAThe premature commanded tow release by the towplane pilot over unsuitable terrain.Jun 2, 1990 · N3836H · Substantial damageNTSB LAX90LA205Accident · Minor injuriesLimited investigationFinal reportCessna 152 II · Rialto, CAPilot's inadequate visual outlook which resulted in an inflight encounter with wake turbulence produced by a hovering helicopter.Jun 2, 1990 · N49796 · Substantial damageNTSB LAX90DVG09Accident · No injuriesFinal reportCullen/Roth Falcon XP · Yountville, CAThe pilot's misjudgement of fuel supply.Jun 2, 1990 · N9939 · Substantial damageNTSB FTW90DPJ06Accident · 1 fatalFinal reportStits SA-3A Playboy · Bartlesville, OKAn inadvertent stall.Jun 2, 1990 · N434K · DestroyedNTSB DEN90LA121Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Las Cruces, NMA loss of power for an unknown cause. A factor in the accident was the unsuitable terrain.Jun 2, 1990 · N436DS · Substantial damageNTSB DCA90MA030Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 737-2X6C · Unalakleet, AKDeficiencies in flightcrew coordination, their failure to adequately prepare for and properly execute the unk LOC rwy 14 nonprecision approach and their subsequent premature descent.Jun 2, 1990 · N670MA · DestroyedNTSB CHI90LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, MIStudent pilot's failure to maintain directional control while landing in a crosswind. The student's lack of flight experience and the crosswind were factors.Jun 2, 1990 · N67727 · Substantial damageNTSB CHI90LA147Accident · No injuriesLimited investigationFinal reportCessna C205 · Anderson, INThe pilot's encounter with unsuitable terrain during the landing roll after a forced landing. Contributing factors in this accident were the total powerplant failure and the IFR weather conditions which limited the landing site selection.Jun 2, 1990 · N8215Z · Substantial damageNTSB CHI90FA145Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Wadsworth, OHThe failure of the certified flight instructor and the dual student to maintain a visual lookout during the final approach to the airport.Jun 2, 1990 · N8760N · DestroyedNTSB BFO90FA053Accident · 2 fatalField investigationFinal reportBeech 36 · Gaithersburg, MDFailure of the pilot to extend the landing gear, which resulted in a wheels up landing; his improper decision to attempt a go around (aborted landing) after the airplane contacted the runway; and his failure to attain or maintain adequate airspeed while…Jun 2, 1990 · N2003A · DestroyedNTSB ATL90LA125Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Montevallo, ALThe inattentiveness of the glider pilot to the aborted takeoff of the tow plane, which resulted in his delayed action in attempting to execute a forced landing. These actions resulted in an inadvertent stall and the aircraft collided with the terrain.Jun 2, 1990 · N34431 · Substantial damageNTSB ANC90LA083Accident · No injuriesLimited investigationFinal reportHelio H-250 · Six Mile Lake, AKThe pilot's improper flare, which resulted in a hard landing. The pilot's lack of experience in the make and model of aircraft was a related factor.Jun 2, 1990 · N528LM · Substantial damageNTSB SEA90LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Palouse, WAThe pilots poorly planned approach for landing.Jun 1, 1990 · N5895D · Substantial damageNTSB MKC90DPG02Accident · 1 fatalFinal reportAero Commander S-2R · Alicia, ARThe pilot's failure to maintian airspeed during the turn to reverse direction for a swath run.Jun 1, 1990 · N8940Q · DestroyedNTSB DEN90FA119Accident · 1 fatalField investigationFinal reportCessna 152 · Longmont, COThe pilot continued into hazardous weather conditions.Jun 1, 1990 · N89834 · DestroyedNTSB CHI90LA143Accident · No injuriesLimited investigationFinal reportCessna 172N · Northwood, OHThe pilot's improper in-flight planning/decision, which resulted in an off-airport landing, when the engine lost power due to fuel exhaustion. The fact that the engine lost power over a populated area was a factor in this accident.Jun 1, 1990 · N737KL · Substantial damageNTSB CHI90DEX01Accident · Minor injuriesFinal reportSattler Aeroduster SA750 · Columbus, INFailure of the pilot to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. The pilot's lack of experience in the airplane was a related factor.Jun 1, 1990 · N85CH · Substantial damageNTSB ANC90LA082Accident · No injuriesLimited investigationFinal reportDe Havilland DHC2 · Broad Pass, AKThe pilot's continued flight into known adverse weather, and his delay in reversing course (improper in-flight planning/decision). Factors related to the accident were: terrain and weather conditions.Jun 1, 1990 · N36841 · Substantial damageNTSB ANC90LA081Accident · No injuriesLimited investigationFinal reportMaule M4 · L. Susitna Riv, AKThe pilot's fuel mismanagement in not having sufficient fuel to reach his destination.Jun 1, 1990 · N4623T · Substantial damageNTSB NYC90LA123Accident · No injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAImproper maintenance and inspection by maintenance personnel of the left gear torque link attachment.May 31, 1990 · N401FC · Substantial damageNTSB NYC90LA122Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Becket, MAA power loss due to oil starvation, after maintenance personnel failed to comply with Lycoming directives during the engine overhaul. Factors related to the accident were: improper adjustment of the engine oil pressure by maintenance personnel and unsuitable…May 31, 1990 · N39268 · Substantial damageNTSB FTW90LA112Accident · No injuriesLimited investigationFinal reportMooney M-20F · Aledo, TXInadequate preflight planning/preparation, in as much as the performance data was not used by the pilot in command. Factors were the high density altitude, inadequate airspeed, and premature liftoff.May 31, 1990 · N6873V · DestroyedNTSB CHI90LA144Accident · No injuriesLimited investigationFinal reportPiper PA23-250 · Carbondale, ILThe pilot's inability to maintain directional control during the touchdown and landing roll.May 31, 1990 · N32AC · Substantial damageNTSB BFO90LA052Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-126E · Warrenton, VAThe pilot misjudged his landing approach.May 31, 1990 · N2958H · Substantial damage