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 BFO92FA069Accident · 2 fatalField investigationFinal reportCessna 172P · Princeton, NJThe pilot's failure to maintain clearance over an obstacle. Contributing factors were a tailwind, dark night, and premature raising of the flaps.May 19, 1992 · N55110 · DestroyedNTSB LAX92TL#06Accident · No injuriesClass 3Final reportMitsubishi MU2B-36 · Edwards Afb, CAMay 18, 1992 · N742FN · Substantial damageNTSB DEN92LA053Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Spring, COThe pilot did not maintain clearance and the airplane collided with a fence post.May 18, 1992 · N146AC · Substantial damageNTSB CHI92LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Osage City, KSThe pilot's failure to maintain directional control. Factors in the accident were the rough/uneven runway surface and the inadequate maintenance of the runway surface.May 18, 1992 · N15619 · Substantial damageNTSB CHI92DTK01Accident · 1 fatalFinal reportPiper PA-25-235 · Iroquois, SDAn improper maneuver and failure to attain level off by the pilot in command while performing aerial application.May 18, 1992 · N4427Y · DestroyedNTSB SEA92LA102Accident · 1 fatalLimited investigationFinal reportBeech S35 · Davenport, WAPoor in flight planning/decision. Factors to the accident were: mountainous/hilly terrain and terrain clearance was not maintained.May 17, 1992 · N9015S · DestroyedNTSB SEA92FA101Accident · 4 fatalField investigationFinal reportMooney M20F · Glendive, MTAn excessive rate of descent, and the pilot's overconfidence in himself and the aircraft.May 17, 1992 · N2920L · DestroyedNTSB MIA92LA124Accident · No injuriesLimited investigationFinal reportCessna 172-P · Daytona Beach, FLThe delayed remedial action by the pilot-in-command (CFI) to the student's pushing the control yoke forward on short final approach.May 17, 1992 · N133ER · Substantial damageNTSB MIA92LA123Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Fort Lauderdale, FLDelay by the CFI to take remedial action. Contributing to the accident was the students premature flare.May 17, 1992 · N4026Q · Substantial damageNTSB BFO92LA068Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Carollton, OHThe pilot's inadequate starting procedure.May 17, 1992 · N6105P · Substantial damageNTSB BFO92LA067Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Vine Grove, KYThe pilot's failure to maintain directional control. Contributing factors were wind gusts and the pilot's inadequate compensation for wind.May 17, 1992 · N93426 · Substantial damageNTSB BFO92LA065Accident · Minor injuriesLimited investigationFinal reportNorth American Navion · Sabina, OHThe pilot's inadequate compensation for wind which resulted in a loss of directional control. Contributing to the accident was wind gusts.May 17, 1992 · N8524H · Substantial damageNTSB SEA92LA103Accident · No injuriesLimited investigationFinal reportE.E. Shilling Q-2 · Billings, MTAn undetermined loss of engine power.May 16, 1992 · N21QQ · Substantial damageNTSB SEA92FA100Accident · 2 fatalField investigationFinal reportAerospatiale SA-341G · Yamhill, ORThe pilot misjudged a maneuver performed at inadequate altitude.May 16, 1992 · N9000E · DestroyedNTSB LAX92LA210Accident · 1 fatalLimited investigationFinal reportCessna 182A · S.Lake Tahoe, CAThat the pilot-in-command used poor judgment by flying at an unwarranted low altitude and misjudged the clearance between the tree tops and the airplane.May 16, 1992 · N2031G · DestroyedNTSB CHI92LA150Accident · No injuriesLimited investigationFinal reportBeech C23 · Saginaw, MIThe first pilot's improper recovery from a bounced landing. A factor in the accident was the first pilot's lack of experience in the aircraft type.May 16, 1992 · N6167Z · Substantial damageNTSB BFO92LA066Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Caldwell, NJThe pilot's improper IFR operation. Contributing was the pilot's lack of recent instrument flight time.May 16, 1992 · N54860 · DestroyedNTSB BFO92FA064Accident · 2 fatalField investigationFinal reportBeech 65 · Madison, VAThe pilot initiated VFR flight into known adverse weather conditions. Contributing to the accident was low ceiling, high terrain, and low altitude.May 16, 1992 · N30RR · DestroyedNTSB ATL92LA103Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Manchester, GAThe inadequate in-flight planning by the pilot.May 16, 1992 · N4867H · Substantial damageNTSB FTW92LA142Accident · Serious injuriesLimited investigationFinal reportBoeing 737-200 · Palacios, TXThe flight's unexpected encounter with moderate turbulence.May 15, 1992 · N67SW · No damageNTSB FTW92LA137Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe failure of the left brake which led to a loss of directional control. A factor was the rough terrain immediately adjacent to the runway.May 15, 1992 · N8629H · Substantial damageNTSB FTW92LA135Accident · No injuriesLimited investigationFinal reportCessna 150M · Stilwell, OKThe pilot inadvertently pushed the nose down during the flare/landing. A factor was the pilot misjudged the flare/landing.May 15, 1992 · N704CJ · Substantial damageNTSB CHI92LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Springfield, MOFailure of the pilot in command to maintain control of the airplane during a downwind landing.May 15, 1992 · N9270J · Substantial damageNTSB ATL92FA102Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Greenville, NCFailure of the pilot to maintain a proper climb rate after takeoff after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, the pilot's self-induced pressure to make the flight, and his lack of total…May 15, 1992 · N2259T · DestroyedNTSB SEA92LA104Accident · No injuriesLimited investigationFinal reportBrantly-Hynes B-2B · Hood River, ORThe delayed remedial action of the pilot (CFI). Factors include lack of total experience in type of aircraft, and lack of total experience in type of operation.May 14, 1992 · N5972X · Substantial damageNTSB SEA92LA099Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Kalispell, MTThe pilot's failure to maintain adequate airspeed during the go-around.May 14, 1992 · CGEAF · Substantial damageNTSB SEA92LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Chubbuck, IDInadequate preflight planning/preparation. A factor to the accident was: a guy wire.May 14, 1992 · N4488Y · Substantial damageNTSB FTW92LA134Accident · No injuriesLimited investigationFinal reportAir Tractor AT-501 · Mooreland, OKThe failure of the number 3 cylinder for undetermined reasons. A factor was the lack of suitable terrain for the ensuing forced landing.May 14, 1992 · N1006T · Substantial damageNTSB FTW92LA132Accident · No injuriesLimited investigationFinal reportSchweizer G-164D · Welsh, LAThe engine failure at liftoff due to the failure of multiple turbine blades and the pilot's inability to maintain directional control during the aborted takeoff.May 14, 1992 · N8331K · Substantial damageNTSB FTW92DRD01Accident · 1 fatalFinal reportAyres S2R · Hebert, LAThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall and collision with terrain.May 14, 1992 · N5637X · DestroyedNTSB BFO92LA062Accident · No injuriesLimited investigationFinal reportContinental Copters MK6B · Middleboro, MAThe pilot's failure to release a tie down strap from the helicopter's skid during the preflight.May 14, 1992 · N9012T · Substantial damageNTSB BFO92LA061Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts S-1S · Hopkinsville, KYThe failure of the number 2 oil ring in the number 4 engine cylinder resulting in oil leakage, loss of oil pressure, and engine power loss.May 14, 1992 · N4MG · DestroyedNTSB ANC92LA074Accident · No injuriesLimited investigationFinal reportCessna 170B · Old Minto, AKThe pilot's selection of unsuitable terrain. A factor relating to the accident was the ditch in the landing area.May 14, 1992 · N1805C · Substantial damageNTSB NYC92GA092Accident · No injuriesFinal reportBeech BE-200 · Roanoke, VAA lightning strike which discharged through the right elevator.May 13, 1992 · N30721 · Substantial damageNTSB LAX92IA209Incident · Minor injuriesIncident investigationFinal reportBoeing 767-222 · Los Angeles, CAA rupture in the airplane's air condition/heat/pressurization/apu duct, along its welded seam. Contributing to the incident was the manufacturers' failure to issue a service bulletin applicalbe to all APU ducts in the systems.May 13, 1992 · N604UA · Minor damageNTSB FTW92LA131Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot of the other airplane delayed compensation for turbulence. A factor was the turbulence.May 13, 1992 · N1518V · 2 aircraft · Substantial damageNTSB CHI92LA149Accident · No injuriesLimited investigationFinal reportCessna 150 · Olathe, KSThe student pilot's improper recovery from a bounced landing, and the instructor's inadequate remedial action(s).May 13, 1992 · N1668Q · Substantial damageNTSB BFO92LA063Accident · No injuriesLimited investigationFinal reportCessna 182M · Vandalia, OHControl interference by a passenger during touchdown.May 13, 1992 · N71879 · Substantial damageNTSB ATL92LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soccastee, SCThe pilot's mismanagement of his fuel in that he exhausted fuel in one tank, then failed to select the tank with fuel.May 13, 1992 · N3841Z · Substantial damageNTSB SEA92LA096Accident · No injuriesLimited investigationFinal reportRobert Griffiths Kitfox MOD II · Burlington, WAThe pilot's overconfidence in his ability, and his overconfidence in the ability of the aircraft. Factors include high/gusty winds, and a fence near the runway.May 12, 1992 · N7183H · Substantial damageNTSB LAX92T#A05Accident · No injuriesClass 3Final reportMcDonnell Douglas 369E · San Diego, CAMay 12, 1992 · N16069 · Substantial damageNTSB FTW92LA130Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fisher, ARThe loss of complete engine for undetermined reasons. A factor was the low altitude and unsuitable terrain.May 12, 1992 · N9640 · Substantial damageNTSB DEN92LA051Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Longmont, COLoss of directional control during landing roll by the pilot under instruction. A factor was: inadequate supervision by the certified flight instructor.May 12, 1992 · N53853 · Substantial damageNTSB CHI92LA148Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Olathe, KSThe in flight separation of the propeller tip. An associated factor is the rough and uneven terrain.May 12, 1992 · N9694K · Substantial damageNTSB BFO92LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Easton, PAThe pilot's inadequate recovery from a bounced landing and failure to maintain directional control.May 12, 1992 · N98951 · DestroyedNTSB ANC92LA073Accident · No injuriesLimited investigationFinal reportCessna C-150K · Beluga, AKThe improper inflt decision by the pilot to land on a remote, private, snow covered airstrip. A factor relating to the accident was the soft, wet snow on the strip.May 12, 1992 · N6202G · Substantial damageNTSB SEA92LA095Accident · Minor injuriesLimited investigationFinal reportRyan ST-3KR · Anacortes, WALoss of engine power due to fatigue failure of the crankshaft counterweight cap screws and separation of the counterweight. A factor relating to the accident was the residential area and lack of suitable terrain for a forced landing.May 11, 1992 · N4223P · DestroyedNTSB FTW92LA129Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Terrell, TXThe pilot's alcoholic impairment of efficiency and judgement which led to his inattention to the amount of fuel remaining in the left fuel tank, resulting in fuel starvation and a total loss of engine power. A factor in the accident was the existence of the…May 11, 1992 · N7152D · Substantial damageNTSB BFO92LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172XP · Milton, DEThe pilot's failure to attain adequate airspeed for climb.May 11, 1992 · N4695K · Substantial damageNTSB BFO92LA057Accident · Serious injuriesLimited investigationFinal reportCessna 210M · West Mifflin, PAThe pilot's inadequate preflight preparation. Contributing to the accident was the unreliable fuel quantity gauges.May 11, 1992 · N1411P · Destroyed