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 ANC97LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's misjudgment of the touchdown point, which led to undershoot and the airplane nosing over.Sep 12, 1997 · N2389M · Substantial damageNTSB MIA97FA242Accident · 1 fatalField investigationFinal reportMooney M20F · Coral Springs, FLThe pilot's misjudging the distance vs. altitude resulting in the collision with the water short of the intended touchdown point of the rough field. Contributing to the accident was the total loss of engine power due to failure of the No. 3 cylinder…Sep 11, 1997 · N6417Q · Substantial damageNTSB FTW97LA344Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Horseshoe Bend, ARFuel starvation due to partially blocked fuel vents. Factors were: the pilot's inadequate preflight inspection of the airplane; the pilot's improper decision to continue operation of the airplane with known deficiencies; and the lack of suitable terrain for…Sep 11, 1997 · N800C · Substantial damageNTSB LAX97LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Murrieta, CAfailure of the flight instructor (CFI) to ensure an adequate preflight of the airplane, and his failure to properly quantify or verify the fuel onboard before departing on a dual instruction flight, which resulted in fuel exhaustion and a forced landing.Sep 10, 1997 · N65406 · Substantial damageNTSB FTW97LA343Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hillsboro, TXFuel contamination from an undetermined source. A factor was the lack of suitable terrain for the forced landing.Sep 10, 1997 · N84PG · Substantial damageNTSB SEA97LA211Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mackay, IDThe pilot misjudged the distance/altitude while on final approach.Sep 9, 1997 · N91019 · Substantial damageNTSB SEA97LA208Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTthe pilot passenger failed to maintain clearance from the power line.Sep 9, 1997 · N5500L · Substantial damageNTSB SEA97FA206Accident · 1 fatalField investigationFinal reportPiper PA-12 · Horseshoe Bend, IDthe pilot's failure to maintain clearance from transmission wires. The wires were a factor.Sep 9, 1997 · N3637M · DestroyedNTSB NYC97LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Leroy, OHa lack of fluid in the brake reservoir, and the pilot's decision to operate the airplane with defective brakes, which led to an overrun during landing and a collision with trees.Sep 9, 1997 · N2480R · Substantial damageNTSB LAX97LA320Accident · Minor injuriesLimited investigationFinal reportBell 206B · Minden, NVA hard landing due to the failure of the pilot to adequately compensate for the wind direction and velocity on initiating his approach to the landing area, resulting in a loss of tail rotor authority.Sep 9, 1997 · N90115 · Substantial damageNTSB FTW97LA342Accident · No injuriesLimited investigationFinal reportBeech V35 · Sulphur Springs, TXthe pilot's delayed extension of the landing gear.Sep 9, 1997 · N9453S · Substantial damageNTSB FTW97LA339Accident · 1 fatalLimited investigationFinal reportRoddie MINI-500 · Idabel, OKThe loss of control in flight for undetermined reasons. A factor was the pilot's lack of total experience in helicopters.Sep 9, 1997 · N42JR · DestroyedNTSB LAX97LA318Accident · No injuriesLimited investigationFinal reportBeech A23A · Tucson, AZthe student pilot's improper recovery from a bounced landing, and failure to maintain adequate airspeed during an attempted go-around, which resulted in a stall and impact with the terrain (runway).Sep 8, 1997 · N2339W · DestroyedNTSB LAX97LA317Accident · Minor injuriesLimited investigationFinal reportBell 206B · Napa, CAFailure of the pilot to perform an adequate preflight, which resulted in him failing to notice and release the tie down chains.Sep 8, 1997 · N770GG · Substantial damageNTSB FTW97FA340Accident · 3 fatalField investigationFinal reportCessna 182N · Montrose, COInadequate preflight and in-flight planning, preparation and decision making. A related factor was the improper use of flaps.Sep 8, 1997 · N9043G · DestroyedNTSB ANC97LA145Accident · No injuriesLimited investigationFinal reportCessna 402C · Buckland, AKThe failure of the pilot of the Cessna 402C, N2649Z, to maintain adequate clearance while taxiing alongside the stationary Cessna 208B, N1123R.Sep 8, 1997 · N2649Z · 2 aircraft · Substantial damageNTSB SEA97LA207Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel AIR 12-Q · Pendleton, ORthe tail wheel assembly spring disconnected.Sep 7, 1997 · N496W · Substantial damageNTSB SEA97LA205Accident · No injuriesLimited investigationFinal reportCessna U206F · Stanley, IDThe pilot's inadequate planning/decision for taking off in the meteorological conditions present at the time. Factors include a high density altitude, gusty winds, downdrafts, and soft terrain in the area of the forced landing.Sep 7, 1997 · N7494Q · Substantial damageNTSB SEA97LA204Accident · 2 fatalLimited investigationFinal reportPiper J-3 · Jordan, MTThe pilot's inadequate remedial action during an inadvertent stall/spin entry. Factors include buzzing, a rapid pull-up, and failure to maintain proper airspeed (Vs).Sep 7, 1997 · N98833 · DestroyedNTSB MIA97LA241Accident · No injuriesLimited investigationFinal reportCessna 182B · Paris, TNTemporary loss of engine power for undetermined reasons res ulting in a forced landing on unsuitable terrain.Sep 7, 1997 · N2794G · Substantial damageNTSB MIA97LA240Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Concord, NCThe failure of the pilot to latch the canopy closed prior to takeoff. This resulted in the canopying opening while on approach to land and the pilot was unable to maintain altitude due to the excessive drag.Sep 7, 1997 · N560SS · Substantial damageNTSB LAX97LA316Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Madera, CAfuel exhaustion due to the pilot's failure to compute the fuel required and the fuel available. The pilot's decision to extend his downwind beyond gliding distance of the runway after entering the traffic pattern was a factor in this accident.Sep 7, 1997 · N81MK · Substantial damageNTSB FTW97LA359Accident · No injuriesLimited investigationFinal reportShutt Marquart MA-5 · Pecos, TXThe pilot's inadequate compensation for the crosswind during a forced landing following a loss of engine power due to fuel exhaustion for an undetermined reason. Factors were the gusty winds and rough/uneven terrain.Sep 7, 1997 · N82ND · Substantial damageNTSB CHI97LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grant, MIthe pilot's fixation on the end of the runway, his failure to place the airplane in an attitude to land (flare) which resulted in a hard landing, and the pilot's failure to recover from the subsequent bounced landing.Sep 7, 1997 · N6391R · Substantial damageNTSB CHI97LA288Accident · No injuriesLimited investigationFinal reportBeech 35-C33A · Amana, IAthe pilot's improper planning/decision. The fence (location) was a related factor.Sep 7, 1997 · N5729V · Substantial damageNTSB CHI97LA285Accident · Serious injuriesLimited investigationFinal reportBritish Aerospace BAE-ATP · Peru, ILsudden/unexpected encounter with clear air turbulence.Sep 7, 1997 · N855AW · No damageNTSB CHI97FA283Accident · 1 fatalField investigationFinal reportCessna 177B · Crump, MIContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC) and her failure to maintain control of the airplane, due to spatial disorientation. Related factors were the low ceiling, and the pilot's lack of instrument…Sep 7, 1997 · N34142 · DestroyedNTSB ANC97LA134Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKThe pilot's inadequate evaluation of the weather conditions. Factors in the accident were a downdraft, crosswind conditions, and rough/uneven terrain.Sep 7, 1997 · N7318U · Substantial damageNTSB SEA97LA203Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Harrah, WAThe pilot's failure to maintain clearance from a transmission wire while on final approach. A factor was a 40-foot high transmission wire located approximately 20 feet from the end of the airstrip.Sep 6, 1997 · N2349J · Substantial damageNTSB NYC97LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Chester, PAthe pilot's misjudgment of altitude and distance to the runway, which resulted in an undershoot and failure to reach the proper touchdown point. Rising terrain at the approach end of the runway was a related factor.Sep 6, 1997 · N4982S · Substantial damageNTSB NYC97FA178Accident · 2 fatalField investigationFinal reportCessna U206B · Gilbertsville, KYThe improper repair of a float by maintenance personnel which resulted in the total failure of the float.Sep 6, 1997 · N206KY · DestroyedNTSB LAX97LA314Accident · Serious injuriesLimited investigationFinal reportHallam RV-6 · Woodlake, CAfailure of the pilot to accurately determine the quantity of fuel onboard the airplane before flight, and subsequent loss of engine power due to fuel starvation, which resulted in a forced landing.Sep 6, 1997 · N93SJ · Substantial damageNTSB IAD97LA118Accident · Serious injuriesLimited investigationFinal reportReynolds MARSKE-MONARCH 1997 · Sutton, WVThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. A related factors was the pilot lack of familiarity with the airplane.Sep 6, 1997 · N5377 · DestroyedNTSB IAD97FA117Accident · 5 fatalField investigationFinal reportCessna 182E · Smithfield, RIA loss of engine power for undetermined reason, and the pilot's failure to maintain control of the airplane.Sep 6, 1997 · N3286Y · DestroyedNTSB FTW97LA341Accident · Serious injuriesLimited investigationFinal reportBurgess Skyhopper · Jonesboro, ARThe pilot's failure to obtain/maintain the aircraft's airspeed. Factors were the high density altitude and the lack of suitable terrain for the forced landing.Sep 6, 1997 · N4186C · Substantial damageNTSB DCA97RA063Accident · No injuriesForeign investigationBoeing 737-200 · Saudi ArabiaSep 6, 1997 · HZ-AGNTSB CHI97LA291Accident · No injuriesLimited investigationFinal reportCessna 177B · Oxford, IAthe instructor pilot's improper recovery from a bounced landing and his failure to maintain control of the airplane. Factors were the improper flare by the dual student and the instructor pilot's lack of familiarity with the airplane.Sep 6, 1997 · N34829 · Substantial damageNTSB CHI97LA287Accident · Serious injuriesLimited investigationFinal reportHiggens Rans S-12 XL · Tuscola, ILthe pilot's failure to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall.Sep 6, 1997 · N7304Q · DestroyedNTSB CHI97LA286Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Shields, KSa loss of engine power from undetermined reasons.Sep 6, 1997 · N9228D · Substantial damageNTSB CHI97LA284Accident · 2 fatalLimited investigationFinal reportNorth American-Aero Classics P-51D · Monroe, MIthe pilot operating the airplane with a known coolant leak, coolant exhaustion, overheating of the engine, and subsequent failure of a connecting rod, which resulted in a partial loss of engine power; and failure of the pilot to see the powerline. The…Sep 6, 1997 · N6345T · DestroyedNTSB ATL97LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Kenly, NCThe pilot's failure to see and avoid a utility line on final approach to land. The sunglare and utility line were factors.Sep 6, 1997 · N6898F · Substantial damageNTSB ATL97FA134Accident · 2 fatalField investigationFinal reportNorth American T-6-SNJ5 · Camden, SCThe pilot's failure to take remedial action after a loss of engine power for undetermined reasons, leading to a spin. Factors were the pilot's use of unapproved medication, and the FAA's inadequate certification and standards for airman.Sep 6, 1997 · N1047C · DestroyedNTSB ANC97FA143Accident · 2 fatalField investigationFinal reportAero Commander AC-500A · Ketchikan, AKThe rupture of the right engine fuel supply line as a result of inadequate inspection by the pilot/mechanic, and the pilot's excessive pull up which resulted in exceeding the design stress limits of the airplane. Factors were the improper emergency procedures…Sep 6, 1997 · N543AN · DestroyedNTSB LAX97LA319Accident · No injuriesLimited investigationFinal reportMooney M20E · Gulf Of Ca (Pacific Ocean)The loss of engine power for undetermined reasons.Sep 5, 1997 · N9217V · DestroyedNTSB LAX97LA313Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Yucca Valley, CAthe driver's failure to see the posted sign and yield to the landing aircraft.Sep 5, 1997 · N8487Q · Substantial damageNTSB IAD97LA119Accident · Minor injuriesLimited investigationFinal reportLuscombe LL-8-F · Carrollton, OHThe pilot's inadequate preflight which resulted in fuel exhaustion.Sep 5, 1997 · N1871K · Substantial damageNTSB ATL97WA145Accident · 1 fatalForeign investigationCessna A188B · Trinidad, WNSep 5, 1997 · 9YTIQ · DestroyedNTSB LAX97LA310Accident · No injuriesLimited investigationFinal reportBingelis Falco F.8L · Watsonville, CAthe pilot's misjudgment of distance and speed on final approach, leading to a landing undershoot.Sep 4, 1997 · N84TX · Substantial damageNTSB FTW97LA338Accident · No injuriesLimited investigationFinal reportBeech V35B · Saguache, CO**This report was modified on 2/23/2016. Please see the public docket for this accident for additional information.** the loss of engine power during cruise for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced…Sep 4, 1997 · N7397R · Substantial damageNTSB ANC97LA142Accident · No injuriesLimited investigationFinal reportMaule ML-4-220C · Aniak, AKThe inadvertent swerve during landing on calm water. A factor was the pilot's lack of certification in single engine seaplanes.Sep 4, 1997 · N2048U · Substantial damage