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 LAX97LA295Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe pilot's inadequate recovery from a bounced landing.Aug 19, 1997 · N3266E · Substantial damageNTSB FTW97LA319Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Montrose, COfailure of the flight instructor (CFI) to properly supervise the flight and ensure that adequate rotor rpm was maintainted during the autorotation/landing. The high density altitude was a related factor.Aug 19, 1997 · N2243W · Substantial damageNTSB FTW97LA315Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Gila, NMthe pilot's impairment of judgment and performance due to alcohol, and his failure to maintain directional control of the airplane, which resulted in a ground swerve, and collision with vegetation (cactus) and a fence. Related factors were: the soft runway…Aug 19, 1997 · N9455J · Substantial damageNTSB FTW97FA313Accident · 2 fatalField investigationFinal reportBeech B24R · Albany, TXThe flight instructor's failure to maintain aircraft control during the takeoff/initial climb. A factor was the flight instructor's lack of experience in the make and model of aircraft.Aug 19, 1997 · N2521W · DestroyedNTSB ANC97LA125Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Karluk, AKthe pilot's selection of unsuitable terrain for landing. Related factors were: the direct left crosswind, and the soft sand.Aug 19, 1997 · N3RY · Substantial damageNTSB SEA97LA193Accident · No injuriesLimited investigationFinal reportCessna TU206G · Edwall, WAA fatigue failure of the engine crankshaft. Factors contributing to the accident were the rolling terrain, and the fence.Aug 18, 1997 · N6620Z · Substantial damageNTSB MIA97LA236Accident · No injuriesLimited investigationFinal reportCessna 182Q · Butler, ALThe failure of the pilot to maintain directional control during a landing attempt after adding power to recover from a bounced landing.Aug 18, 1997 · N86TC · Substantial damageNTSB LAX97LA294Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZThe student's failure to maintain directional control due to excessive use of the rudder, and the instructor's delayed remedial action.Aug 18, 1997 · N57528 · Substantial damageNTSB LAX97FA292Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Kernville, CAThe partial loss of engine power due to the operator's inadequate engine maintenance relating to excessively rich mixtures (high fuel flow rates) and spark plug/magneto deficiencies. Contributing factors were degraded climb performance resulting from the high…Aug 18, 1997 · N6654A · DestroyedNTSB FTW97LA318Accident · No injuriesLimited investigationFinal reportCessna 175 · Rock Springs, WYThe delayed landing flare by both student pilot and flight instructor, and the flight instructor's inadequate supervision of the student. Factors were the no flap steep approach at low airspeed.Aug 18, 1997 · N7518M · Substantial damageNTSB FTW97LA316Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Caldwell, TXThe loss of engine power due to fuel exhaustion which resulted from a leaking fuel cap. Factors were the dark night conditions, and the lack of suitable terrain for the forced landing.Aug 18, 1997 · N6667P · Substantial damageNTSB ANC97LA124Accident · No injuriesLimited investigationFinal reportCessna 180H · Arctic Village, AKThe pilot's inadequate compensation for gusty wind conditions. Factors were the gusty wind conditions, and the pilot's misjudging the wind information.Aug 18, 1997 · N91412 · DestroyedNTSB SEA97LA192Accident · No injuriesLimited investigationFinal reportCessna 175 · Lynnwood, WAThe pilot's inadequate preflight planning and preparation, which led to fuel exhaustion and subsequent loss of engine power.Aug 17, 1997 · N7533M · Substantial damageNTSB SEA97LA191Accident · Minor injuriesLimited investigationFinal reportBell 47G · Wellpinit, WAThe pilot's selection of an unsuitable landing site, and his failure to maintain rotor blade clearance from terrain during landing.Aug 17, 1997 · N9571 · Substantial damageNTSB NYC97LA166Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Perkasie, PAthe pilot's inadequate preflight, by failing to verify the fuel supply, which led to subsequent fuel exhaustion and loss of engine power. A related factor was: the inaccurate fuel quantity gauge.Aug 17, 1997 · N1224S · Substantial damageNTSB MIA97LA235Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Villa Rica, GAInadequate runway maintenance by the pilot for allowing trees to be in close proximity of the runway and failure to maintain clearance from the trees.Aug 17, 1997 · N5713Z · Substantial damageNTSB LAX97FA291Accident · 1 fatalField investigationFinal reportHefner Pitts S1S · Van Nuys, CAthe operation of the propeller beyond the design rpm limitations and the resultant gyroscopic loads from aerobatics. Contributing to the accident was the lack of a required instrument panel rpm restriction for the propeller mandated by an airworthiness…Aug 17, 1997 · N10HJ · DestroyedNTSB FTW97LA317Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Vernon, TXfailure of the pilot to maintain clearance from an irrigation pipe. Factors relating to the accident were: the poor light condition at dusk, the object (vertical piece of irragation pipe), loss of engine power from foreign object damage, and the lack of…Aug 17, 1997 · N2316X · Substantial damageNTSB CHI97LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glenwood, MNfailure of the student pilot to maintain the correct airspeed for a go-around maneuver, which resulted in a stall/mush and collision with terrain.Aug 17, 1997 · N23236 · Substantial damageNTSB CHI97LA262Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Jefferson City, MOthe pilot's incomplete preflight of the airplane's stabilizer and rudder trim settings for takeoff, his failure to correct for the high pitch during the initial climb, his failure to recover from the bounced landing, and the inadvertent stall. Factors…Aug 17, 1997 · N8147B · Substantial damageNTSB CHI97LA260Accident · No injuriesLimited investigationFinal reportCessna 182 · Derby, KSthe Airworthiness Directive and propeller overhaul not being complied with. Factors to the accident were the propeller blade retention failure and rough/uneven terrain condition.Aug 17, 1997 · N9952T · DestroyedNTSB SEA97LA190Accident · Minor injuriesLimited investigationFinal reportLaister LP-49 · North Plains, ORThe pilot's selection of an inadequate landing site, and his failure to adequately plan his return glide back to his home gliderport. A factor contributing to the accident was rough terrain.Aug 16, 1997 · N40NH · Substantial damageNTSB MIA97LA234Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Siler City, NCFailure of the pilot to obtain a preflight weather briefing, inaccurate weather evaluation by the pilot, and his poor in-flight planning decision for descending too low to read a road sign.Aug 16, 1997 · N2237H · Substantial damageNTSB MIA97LA233Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Waynesboro, GAThe obscured vision of the pilot due to oil covering the windscreen. Contributing to the accident was the partial loss of engine power due to a cracked head of one of the cylinders and unsuitable terrain encountered during the forced landing.Aug 16, 1997 · N4411S · Substantial damageNTSB IAD97LA111Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Westfield, MAThe pilot's inadequate preflight preparation which fail to include a weight and balance check and his subsequent failure to maintain aircraft control.Aug 16, 1997 · N16040 · Substantial damageNTSB CHI97LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Burlington, WIthe deer which contacted the airplane.Aug 16, 1997 · N7016Y · Substantial damageNTSB CHI97LA261Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Hinckley, ILthe failure of the glider pilot to properly handle his airplane during the initial takeoff climb which resulted in the tow pilot's inability to maintain control of his airplane.Aug 16, 1997 · N9781P · DestroyedNTSB CHI97LA259Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bradshaw, NEthe pilot not maintaining clearance from the terrain. Factors contributing to this accident were the pilot's diverted attention due to the problems with his global positioning flagger equipment and the other ag- airplane, and the crop.Aug 16, 1997 · N8622L · Substantial damageNTSB SEA97LA189Accident · Minor injuriesLimited investigationFinal reportRotz RAF 2000 GTX SE · Olympia, WAThe pilot's failure to attain adequate rotor rpm prior to takeoff.Aug 15, 1997 · N9155H · Substantial damageNTSB NYC97LA190Accident · No injuriesLimited investigationFinal reportBeech 58TC · E. Farmingdale, NYthe pilot's improper starting procedure, which led to an engine fire; and his failure to follow the emergency checklist, which contributed to the level of damage that the airplane received.Aug 15, 1997 · N2152L · Substantial damageNTSB MIA97LA231Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Pinehurst, GAThe failure of the pilot to maintain clearance with the cotton crop while maneuvering to begin a spray pass over a 5 foot-tall cotton crop, resulting in the in-flight collision with the crop and terrain.Aug 15, 1997 · N8721H · Substantial damageNTSB LAX97TA289Accident · Minor injuriesFinal reportBell UH-1H · Tahoe City, CAThe pilot's decision to attempt a takeoff in environmental conditions which exceeded the helicopter's performance capability, and his improper use of the collective, which caused a decay of the main rotor rpm, the collision with the lake, and the subsequent…Aug 15, 1997 · N205DF · Substantial damageNTSB LAX97LA293Accident · No injuriesLimited investigationFinal reportCessna 188 · Eloy, AZThe pilot's improper recovery from a bounced landing and his failure to maintain directional control due to inadequate rudder use.Aug 15, 1997 · N9957J · Substantial damageNTSB LAX97FA288Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Corcoran, CAThe pilot's failure to maintain separation from ground obstacles.Aug 15, 1997 · N96294 · DestroyedNTSB FTW97RA314Accident · 8 fatalForeign investigationBell 412HP · Cuernavaca, MexicoAug 15, 1997 · XCPFINTSB FTW97LA312Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Longmont, COThe pilot in command's failure to maintain directional control of the aircraft, resulting in an inadvertent ground loop.Aug 15, 1997 · N2849M · Substantial damageNTSB FTW97LA310Accident · No injuriesLimited investigationFinal reportWaco KNF · Wamsutter, WYThe pilot's failure to maintain directional control during the precautionary landing. A factor was a wind gust.Aug 15, 1997 · NC698N · Substantial damageNTSB SEA97FA188Accident · Serious injuriesField investigationFinal reportBeech 1900C · Seattle, WAA stall/mush condition resulting from an aft center of gravity which was inaccurately provided to the pilot-in-command by contractual cargo-loading personnel. Additional causes were overloading of the aircraft's landing gear and fuel leakage resulting in a…Aug 14, 1997 · N3172A · DestroyedNTSB NYC97LA165Accident · No injuriesLimited investigationFinal reportDassault DA-20 · Lexington, KYThe pilot misjudged distance and altitude to the runway after transition from an instrument approach to a visual approach. Factors related to the accident were the rain, and uphill runway conditions at a dark night.Aug 14, 1997 · N227R · Substantial damageNTSB MIA97FA232Accident · 1 fatalField investigationFinal reportBeech 200 · Dalton, GAthe pilot's improper IFR procedure, by failing to maintain the minimum descent altitude (MDA) during the ILS localizer approach, until the runway environment was in sight, which resulted in a collision with terrain short of the runway. Factors relating to the…Aug 14, 1997 · N74EJ · Substantial damageNTSB LAX97LA290Accident · No injuriesLimited investigationFinal reportCessna 185 · Buckeye, AZThe pilot's misjudgement of the clearance between the aircraft and the tree.Aug 14, 1997 · N1023F · Substantial damageNTSB IAD97LA110Accident · No injuriesLimited investigationFinal reportCessna 170B · Jamestown, NYThe pilot's failure to maintain control of the airplane during a crosswind landing.Aug 14, 1997 · N3454C · Substantial damageNTSB CHI97LA257Accident · No injuriesLimited investigationFinal reportCessna A188B · Elwood, NEthe pilot not maintaining clearance from the bushes. Factors contributing to this accident were the pilot's inadequate preparation prior to the takeoff attempt, his changing flap positions during the takeoff run which degraded the airplane's performance…Aug 14, 1997 · N731GE · Substantial damageNTSB ANC97LA123Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kaktovik, AKThe pilot's selection of an unsuitable takeoff area. A factor related to the accident was the rocky terrain.Aug 14, 1997 · N5507H · Substantial damageNTSB ANC97LA122Accident · No injuriesLimited investigationFinal reportStinson 108 · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. A factor was the crosswind.Aug 14, 1997 · N97959 · Substantial damageNTSB SEA97LA187Accident · No injuriesLimited investigationFinal reportCessna 140 · Hillsboro, ORThe pilot's failure to maintain directional control during landing.Aug 13, 1997 · N76233 · Substantial damageNTSB LAX97LA287Accident · Serious injuriesLimited investigationFinal reportAerostar S-55A · Marana, AZThe pilot's in-flight planning/decision to continue his flight after striking a fence, and his inability to attain the proper climb rate, which subsequently led to the in-flight collision with the transmission power line.Aug 13, 1997 · N3607B · DestroyedNTSB MIA97LA229Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Pink Hill, NCFailure of the dual student to maintain airspeed resulting in an inadvertent stall and uncontrolled descent until ground impact. Contributing to the accident was improper supervision of the dual student by the pilot-in-command flight instructor.Aug 12, 1997 · N6043T · Substantial damageNTSB LAX97LA285Accident · No injuriesLimited investigationFinal reportBell 47G2 · Mojave, CAThe student's improper use of the throttle and collective controls and the flight instructor's inadequate supervision of the flight.Aug 12, 1997 · N9021R · Substantial damageNTSB LAX97LA284Accident · No injuriesLimited investigationFinal reportCessna 152 · San Manuel, AZThe student pilot's improper recovery from a bounced landing, and failure to maintain directional control of the aircraft. A factor related to the accident was the pilot's fatigue from improper rest the evening before the flight.Aug 12, 1997 · N757CS · Substantial damage