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 BFO93LA142Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Matawan, NJThe water collection in the ignition harness which rendered the lower cylinder spark plugs inoperative resulting in partial power loss.Jul 30, 1993 · N6617X · Substantial damageNTSB ANC93LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe pilot's failure to maintain directional control of the airpalne. A factor in the accident was the ditch along the side of the runway.Jul 30, 1993 · N5076E · Substantial damageNTSB ANC93LA130Accident · 2 fatalLimited investigationFinal reportCessna 170 · Dry Bay, AKUndetermined.Jul 30, 1993 · N8190A · DestroyedNTSB SEA93LA167Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monroe, WAThe improper inflight decision by the PIC and his failure to attain proper runway alignment. Factors relating to the accident were the dark night light conditions, unavailability of runway lights, and lack of recent night flight time by the PIC.Jul 29, 1993 · N734DL · Substantial damageNTSB LAX93LA307Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Santa Margarita, CAthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Jul 29, 1993 · N45138 · DestroyedNTSB LAX93LA306Accident · No injuriesLimited investigationFinal reportAyres S-2R-T34 · Tulare, CAthe failure of the main gear inner lower tube assembly due to fatigue.Jul 29, 1993 · N4016B · Substantial damageNTSB DEN93FA090Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Elk Springs, COThe performance of a stall/spin at an altitude inadequate for recovery and level off.Jul 29, 1993 · N5035K · DestroyedNTSB CHI93LA306Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Liberty, MOThe pilot's failure to maintain adequate aircraft control during the emergency landing. A factor is the pilot's lack of experience in the aircraft.Jul 29, 1993 · N2663H · Substantial damageNTSB CHI93LA282Accident · No injuriesLimited investigationFinal reportGrumman G164 · Brule, NEThe unsuitable terrain encountered. Factors relating to this accident include total failure of an engine cylinder, and a hidden obstruction.Jul 29, 1993 · N8368 · Substantial damageNTSB ATL93LA137Accident · 1 fatalLimited investigationFinal reportWard Long EZE · Murfreesboro, TNThe pilot's failure to properly use the carburetor heat control which resulted in the formation of carburetor ice.Jul 29, 1993 · N850JW · Substantial damageNTSB LAX93T#A06Accident · No injuriesClass 3Final reportBell 206B3 · Pine, AZJul 28, 1993 · N5009G · Substantial damageNTSB LAX93LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, CAThe cfi's inadequate supervision of the flight, the improper recovery from the bounced landing by the crew, and the lack of total experience in giving dual instruction by the CFI. Factors which contributed to this accident were: the dual student's improper…Jul 28, 1993 · N69208 · Substantial damageNTSB LAX93LA303Accident · No injuriesLimited investigationFinal reportAyres S2R · Stratford, CAThat the pilot misjudged the airplane's altitude. Factors relating to this accident were the pilot's fatigue and the light conditions.Jul 28, 1993 · N4930X · DestroyedNTSB LAX93LA302Accident · No injuriesLimited investigationFinal reportRobinson R22-B · Venice, CAThe failure of the pilot to maintain proper main rotor RPM, altitude, and airspeed during the performance of a steep turn. Inadequate in-flight planning and overconfidence in the pilot's abilities were factors in this accident.Jul 28, 1993 · N23517 · Substantial damageNTSB DEN93LA088Accident · Serious injuriesLimited investigationFinal reportPiper J3C-90 · Meeker, COFailure of the pilot to maintain adequate terrain clearance. A factor was the intentional low pass performed by the pilot in command.Jul 28, 1993 · N33111 · DestroyedNTSB CHI93LA294Accident · No injuriesLimited investigationFinal reportNorth American F-51 · Fond Du Lac, WIthe pilot-in-command of the F-51's diverted attention and failure to maintain a visual outlook.Jul 28, 1993 · N6327T · 2 aircraft · Minor damageNTSB CHI93LA293Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Oshkosh, WIThe pilot-in-command's not maintaining directional control. Factors include a crosswind, the pilot-in-command's not attaining compensation for wind conditions, and his lack of experience in this type of airplane.Jul 28, 1993 · N81598 · Substantial damageNTSB CHI93LA291Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Houghton, MIthe pilot-in-command not following instrument procedures by not using the correct altimeter setting as issued by Air Traffic Control.Jul 28, 1993 · N4518S · DestroyedNTSB CHI93LA290Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Troy, MIIs the pilot not attaining the proper touchdown point, not flying a proper glidepath, and not performing a go around.Jul 28, 1993 · N40023 · Substantial damageNTSB BFO93LA140Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Woodbine, NJThe pilot maintaining too steep of an angle of climb and an inadequate airspeed which resulted in an inadvertent stall/mush and subsequent loss of control in flight resulting in a collision with the runway. The pilot's lack of experience in the type of…Jul 28, 1993 · N2971D · Substantial damageNTSB ATL93FA136Accident · Serious injuriesField investigationFinal reportCessna 172M · Harvest, ALThe pilot's poorly planned approach and the failure of the pilot to execute a go-around.Jul 28, 1993 · N13738 · Substantial damageNTSB SEA93LA166Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Dayton, WAThe loss of engine power, undetermined. A factor relating to the accident was a fence in the flt path.Jul 27, 1993 · N5646J · Substantial damageNTSB SEA93LA165Accident · No injuriesLimited investigationFinal reportRiches Avid Flyer · Tooele, UTThe failure of the PIC to maintain directional control and to correct a ground loop/swerve.Jul 27, 1993 · N160VR · Substantial damageNTSB SEA93LA164Accident · No injuriesLimited investigationFinal reportChampion 7EC · Chewelah, WAThe failure of the PIC to maintain directional control and correct for ground loop/swerve.Jul 27, 1993 · N4394C · Substantial damageNTSB SEA93LA163Accident · No injuriesLimited investigationFinal reportCessna 195 · Pray, MTThe PIC failed to maintain directional control. A factor relating to the accident was the tailwind weather condition.Jul 27, 1993 · N9836A · Substantial damageNTSB FTW93LA219Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Vidor, TXControl cable separation due to the throttle power lever linkage not being secured by retainer resultant from improper installation. A factor was a lack of suitable terrain for the forced landing.Jul 27, 1993 · N4134X · Substantial damageNTSB FTW93LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · League City, TXVisual lookout not maintained by the driver of the vehicle. A factor was the driver of the vehicle becoming inadvertently lost.Jul 27, 1993 · N3079M · Substantial damageNTSB DEN93LA087Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Wray, COThe pilot's inadequate compensation for the wind conditions and improper recovery from a bounced landing. The gusty crosswind was a factor.Jul 27, 1993 · N3617X · DestroyedNTSB DEN93FA089Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Durango, COThe pilot's entry into a box canyon at an altitude insufficient to clear mountainous terrain.Jul 27, 1993 · N3783K · DestroyedNTSB CHI93LA303Accident · No injuriesLimited investigationFinal reportSchweizer G167B · Borup, MNthe loss of engine power due to a cracked cylinder head.Jul 27, 1993 · N6637Q · Substantial damageNTSB CHI93LA289Accident · No injuriesLimited investigationFinal reportChampion 402 · Valparaiso, INFailure of the exhaust stack assembly.Jul 27, 1993 · N9981Y · Substantial damageNTSB CHI93LA288Accident · No injuriesLimited investigationFinal reportMurphy Rebel · Pickett, WIThe pilot's inadequate preflight planning which resulted in fuel exhaustion. The lack of suitable terrain for a forced landing was a factor in the accident.Jul 27, 1993 · CFNVM · Substantial damageNTSB CHI93LA287Accident · No injuriesLimited investigationFinal reportCessna T210M · Neosho, MOIs the pilot in command's failure to maintain proper clearance. Factors relating to this accident are the pilot in command's inadequate preflight preparation and the loss of total engine power as a result of fuel exhaustion.Jul 27, 1993 · N761DD · Substantial damageNTSB CHI93LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Crookston, MNThe pilot in command's delayed in-flight decision. A factor to the accident is the pilot in command's failure to attain a proper touchdown point.Jul 27, 1993 · N172ND · Substantial damageNTSB ATL93IA135Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Charleston, SCWas the pilot's failure to maintain adequate airspeed during the landing attempt which resulted in a stall and the subsequent collision with the runway.Jul 27, 1993 · N948DL · Minor damageNTSB ANC93FA128Accident · No injuriesField investigationFinal reportConvair 240 · Boise, IDThe pilot's failure to extend the landing gear, and the check pilot's inadequate supervisiion. A factor in the accident was the pilot's inadequate upgrade training by the company.Jul 27, 1993 · N156PA · Substantial damageNTSB SEA93LA161Accident · No injuriesLimited investigationFinal reportBell B206BII · Lake Powell, UTA power loss for undetermined reasons. Factors include landing in water.Jul 26, 1993 · N502AH · Substantial damageNTSB MIA93T#A02Accident · No injuriesClass 3Final reportHughes 369E · Carolina, PRJul 26, 1993 · N126PD · Substantial damageNTSB MIA93LA165Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31A · Columbus, MSThe pilot-in-command's improper decision to turn the fuel selector off prematurely during his attempted landing.Jul 26, 1993 · N39850 · Substantial damageNTSB LAX93LA301Accident · Minor injuriesLimited investigationFinal reportFerdon Thorp S-18 · Ash Fork, AZThe pilots inadequate compensation for wind conditions and failure to maintain directional control of the airplane during a precautionary landing, that resulted in collision with a fence and nose over of the airplane. A cross wind condition was a factor in…Jul 26, 1993 · N119FF · Substantial damageNTSB LAX93FA377Accident · 3 fatalField investigationFinal reportBeech F33A · Baker, CAA loss of control for undetermined reason(s).Jul 26, 1993 · N3022W · DestroyedNTSB LAX93FA300Accident · 6 fatalField investigationFinal reportCessna 310H · Lancaster, CAthe pilot's improper in-flight planning/decision and his failure to maintain the minimum control airspeed which progressed to an inadverent stall/spin. Factors relating to this accident were fuel exhaustion and the pilot's lack of experience in the accident…Jul 26, 1993 · N310HJ · DestroyedNTSB CHI93MA276Accident · 3 fatalMajor investigationFinal reportCanadair CL-600-2B19 · Byers, KSThe captain's failure to adhere to the agreed upon flight test plan for ending the test maneuver at the onset of prestall stick shaker, and the flightcrew's failure to assure that all required switches were properly positioned for anti-spin chute deployment.…Jul 26, 1993 · CFCRJ · DestroyedNTSB CHI93LA286Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Birmingham, MIAn improper grade of fuel was loaded into the airplane by the owner/operator of the rental airplane, improper planning and/or decision by the pilot, and subsequent vapor lock in the fuel system of the airplane (fuel system - other), which resulted in fuel…Jul 26, 1993 · N1976W · Substantial damageNTSB CHI93LA284Accident · No injuriesLimited investigationFinal reportCessna 177RG · Columbus, INthe pilot in command's failure to maintain proper clearance. A factor involved in this accident is the pilot in command's failure to maintain a proper glidepath.Jul 26, 1993 · N1850Q · Substantial damageNTSB CHI93LA278Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · West Plains, MOThe loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.Jul 26, 1993 · N6723B · DestroyedNTSB NYC93FA137Accident · No injuriesField investigationFinal reportBoeing 747-368 · Jamaica, NYMissjudged clearance by the captain of the B-747, hz-ais, as he attempted to maneuver around the ATR-42, N242AT. A factor related to the accident was the diverted attention of the captain of the B-747.Jul 25, 1993 · HZAIS · 2 aircraft · Minor damageNTSB MIA93LA164Accident · Serious injuriesLimited investigationFinal reportMaxair AVR-582 · Wimauma, FLThe pilot-in-commands failure to maintain airspeed while making a forced landing following loss of engine power resulting in the aircraft stalling and descending uncontrolled to the ground.Jul 25, 1993 · UNREG · Substantial damageNTSB MIA93FA163Accident · 3 fatalField investigationFinal reportBeech C23 · St Petersburg, FLFailure of the pilot to maintain adequate airspeed during the go-around, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's lack of familiarity with the airport, and his selection of the wrong runway.Jul 25, 1993 · N60093 · DestroyedNTSB LAX93LA363Accident · No injuriesLimited investigationFinal reportCessna 210A · Salinas, CAAn undetermined loss of engine power during the final approach phase of landing resulting in a collision with terrain during the forced landing.Jul 25, 1993 · N9520X · Substantial damage