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 ATL94LA089Accident · No injuriesLimited investigationFinal reportHesterlee Rutan Vari EZE · Statesville, NCThe pilot's improper positioning of the fuel selector, which resulted in fuel starvation during the initial climb after takeoff. A factor was a ditch adjacent to the runway.May 1, 1994 · N41ES · Substantial damageNTSB ATL94IA088Incident · No injuriesIncident investigationFinal reportFokker F28 MK 0100 · Charlotte, NCThe improper rigging of the nose wheel steering system by company maintenance personnel.May 1, 1994 · N890US · Minor damageNTSB SEA94LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monarch, MTPoor in flight planning/decision. A factor to the accident was downdrafts.Apr 30, 1994 · N739CW · Substantial damageNTSB SEA94LA112Accident · No injuriesLimited investigationFinal reportBeech A24R · Everett, WAFuel system pump contamination and procedures/directives were not followed.Apr 30, 1994 · N24661 · Substantial damageNTSB SEA94FA111Accident · Serious injuriesField investigationFinal reportCessna TU206G · Gold Bar, WAElectrical system short. Factors to the accident were: mountainous terrain and procedures/directives not followed.Apr 30, 1994 · N732JK · Substantial damageNTSB MIA94LA130Accident · Serious injuriesLimited investigationFinal reportAir Creation GTX Trike · Englewood, FLWas the failure of the pilot-in-command to maintain airspeed resulting in an inadvertent stall at an altitude insufficient for recovery.Apr 30, 1994 · UNREG · Substantial damageNTSB FTW94FA140Accident · 2 fatalField investigationFinal reportCessna 150M · Arroyo City, TXThe pilot's inadvertent stall during the pull up. Factors were the low pass, his ostentatious display, and his inability to recover from the stall due to insufficient altitude.Apr 30, 1994 · N190AR · DestroyedNTSB CHI94LA145Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Rochelle, ILthe pilot's inadequate use of carburetor heat. Factors associated with the accident were carburetor icing conditions and rough terrain.Apr 30, 1994 · N7605P · Substantial damageNTSB CHI94LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Willmar, MNthe failure of the pilot in command to maintain directional control during touch and go landings. A factor was the pilot in command's lack of total experience and the snowbank located off the side of the runway.Apr 30, 1994 · N758ZC · Substantial damageNTSB BFO94LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Hollis, NHThe pilot's inadequate preflight inspection which failed to detect contaminated fuel which resulted in fuel starvation.Apr 30, 1994 · N5907G · Substantial damageNTSB BFO94LA080Accident · No injuriesLimited investigationFinal reportCessna 150L · Farmingdale, NJThe student pilot's improper flare and the flight instructor's inadequate supervision.Apr 30, 1994 · N1561Q · Substantial damageNTSB ATL94LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bainbridge, GAThe unsecured rear seat back which fell forward and jammed the flight controls.Apr 30, 1994 · N6879B · Substantial damageNTSB ATL94LA087Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellijay, GAThe inadvertent deployment of the parachute because of the jumpmaster's inattention to the static line.Apr 30, 1994 · N2673G · Substantial damageNTSB SEA94LA115Accident · No injuriesLimited investigationFinal reportCessna 172P · Hillsboro, ORPoor in-flight planning. Factors to the accident were: inadequate remedial action and uncontrolled porpoise.Apr 29, 1994 · N53161 · Substantial damageNTSB MIA94LA128Accident · Minor injuriesLimited investigationFinal reportKeuthan Sabre II / S2A · Merritt Island, FLThe pilot-in-command's inadequate fuel consumption calculations and inadequate in-flight planning when encountering a headwind.Apr 29, 1994 · N692KA · Substantial damageNTSB DCA94MA053Accident · 8 fatalClass 1 · MajorFinal reportPiper PA31 · Stratford, CTThe failure of the captain to use the available ILS glideslope, his failure to execute a go-around when conditions were not suitable for landing, and his failure to land the airplane at a point sufficient to allow for a safe stopping distance; the fatalities…Apr 28, 1994 · N990RA · DestroyedNTSB SEA94LA110Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Lander, WYPoor in-flight planning decision. Factors to the accident were: whiteout conditions and inadvertent VFR into IMC.Apr 27, 1994 · N134Q · Substantial damageNTSB LAX94IA206Incident · Minor injuriesIncident investigationFinal reportBoeing 737-209 · Honolulu, HIThe failure of the battery transfer relay resulting in multiple system failures.Apr 27, 1994 · N804AL · No damageNTSB FTW94IA139Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYA partial failure of the leading edge tip portion of one of the left engine propeller blades due to previous impact damage from an unknown source.Apr 27, 1994 · N141UE · Minor damageNTSB FTW94FA138Accident · 2 fatalField investigationFinal reportCessna A150K · Mccrory, ARWas the inadvertent stall and spin. Factors were the pilot's performance of aerobatics at an inadequate altitude.Apr 27, 1994 · N8457M · DestroyedNTSB CHI94LA151Accident · No injuriesLimited investigationFinal reportAeronca 11 AC · Carmi, ILpoor preflight planning/preparation. Factors associated with the accident were the high vegetation (grass) and the ditch.Apr 27, 1994 · N9167E · Substantial damageNTSB CHI94LA142Accident · No injuriesLimited investigationFinal reportBell 47G · Springfield, MOthe pilot-in-command misjudging the autorotation and improper use of collective.Apr 27, 1994 · N46DH · Substantial damageNTSB BFO94LA079Accident · Serious injuriesLimited investigationFinal reportPitts S2B · Williamstown, NJthe pilot's failure to accurately determine the fuel supply, which resulted in fuel exhaustion and a subsequent forced landing.Apr 27, 1994 · N93AN · Substantial damageNTSB MIA94LA127Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Bushnell, FLThe pilot-in-command's improper landing flare during a forced landing, resulting in a hard landing and separation of the right main landing gear. Contributing to the accident was a partial loss of engine power due to a loose exhaust valve seat on the No. 3…Apr 26, 1994 · N9530A · Substantial damageNTSB BFO94LA078Accident · Minor injuriesLimited investigationFinal reportCameron ET-90 · Louisville, KYThe pilot-in-command's failure to maintain clearance from wires during the landing approach. A factor related to the accident is a downdraft that exceeded the balloon's available climb capability.Apr 26, 1994 · N898ET · Substantial damageNTSB SEA94LA109Accident · Minor injuriesLimited investigationFinal reportBell 206B · Summerville, ORThe pilot did not maintain clearance from the wires. The overcast sky condiiton was a factor.Apr 25, 1994 · N35BL · DestroyedNTSB BFO94LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Westminster, MDThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and the inflight loss of control. A factor is the pilot's failure to do a go around.Apr 25, 1994 · N11522 · DestroyedNTSB ATL94LA086Accident · No injuriesLimited investigationFinal reportFerguson Fergy II · Nashville, TNThe pilot's failure to maintain clearance from a utility wire during climbout.Apr 25, 1994 · N71797 · Substantial damageNTSB SEA94FA106Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Kellogg, IDFailure of the pilot to maintain aircraft control, due to spatial disorientation, while flying with partial panel, and the design stress limits of the aircraft being exceeded. Factors related to the accident were: failure of the vacuum system, which resulted…Apr 24, 1994 · N7659C · DestroyedNTSB MIA94LA126Accident · Minor injuriesLimited investigationFinal reportParsons BP Gyro · Bunnell, FLThe pilot-in-command's improper use of the flight controls during landing flare touchdown, resulting in the gyroplane touching down on the nose gear, and subsequent nose over. The loss of engine power was also a cause.Apr 24, 1994 · N54WP · Substantial damageNTSB LAX94LA204Accident · No injuriesLimited investigationFinal reportBeech UC-45J · Acampo, CAThe pilot's failure to use carburetor heat during the extended power-off descent. The existing carburetor icing conditions, the pilot's diverted attention, and the power lines were factors in this accident.Apr 24, 1994 · N35095 · Substantial damageNTSB BFO94LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · New Carlisle, OHThe pilot's inattention to the mixture control which was inadvertently placed in the idle cut-off position by the passenger and resulted in a loss of engine power. A factor is the pilot's inadequate planning.Apr 24, 1994 · N5855W · Substantial damageNTSB SEA94LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Snohomish, WAPoor in-flight planning/decision. A factor to the accident was: high vegetation.Apr 23, 1994 · N70277 · Substantial damageNTSB SEA94LA107Accident · No injuriesLimited investigationFinal reportRich RV-4 · Weston, IDThe pilot's failure to use carburetor heat. Factors include carburetor icing conditions, and no suitable site for a forced landing.Apr 23, 1994 · N3344E · Substantial damageNTSB LAX94LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAThe pilot's improper use of the brakes.Apr 23, 1994 · N6774K · Substantial damageNTSB LAX94LA202Accident · Minor injuriesLimited investigationFinal reportMooney M20-C · Page, AZThe failure of the pilots to assure that ample fuel would be available to reach the airport. The generator failure and an inoperative fuel quantity gage were contributing factors.Apr 23, 1994 · N6524U · Substantial damageNTSB LAX94IA203Incident · Minor injuriesIncident investigationFinal reportFairchild SA-227 · Santa Monica, CAFAA inadequate separation standards between large and heavy category aircraft.Apr 23, 1994 · N27220 · Minor damageNTSB FTW94LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Hempstead, TXThe pilot's improper selection of the strip between the two runways. Factors were the pilot not being familiar with the airstrip and the soft, wet terrain.Apr 23, 1994 · N2302N · Substantial damageNTSB FTW94LA135Accident · No injuriesLimited investigationFinal reportSavage Kitfox · Longmont, COThe pilot's failure to maintain directional control.Apr 23, 1994 · N446GS · Substantial damageNTSB FTW94LA134Accident · Serious injuriesLimited investigationFinal reportWeatherly 201C · Sterling, COAn inadvertent stall. Factors were fuel exhaustion and the pilot's failue to refuel the airplane.Apr 23, 1994 · N1295W · DestroyedNTSB FTW94LA132Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Azle, TXThe instructor pilot's failure to maintain terrain and obstacle clearance. A factor was the instructor's diverted attention.Apr 23, 1994 · N86862 · DestroyedNTSB CHI94LA141Accident · No injuriesLimited investigationFinal reportCessna 182P · Kahoka, MOThe pilot's failure to determine the wind conditions before attempting to land in conditions which exceeded the performance capability of the airplane.Apr 23, 1994 · N1483M · Substantial damageNTSB CHI94FA140Accident · 1 fatalField investigationFinal reportVavra, Martin A. Rebel 300 · Wonderlake, ILFatigue and catastrophic failure of the main wing spar resulting from the designer's excessive, unverified estimate of the strength of the spar cap material and the manufacturer's failure to attain the specified strength during the production process.Apr 23, 1994 · N12MV · DestroyedNTSB BFO94LA075Accident · No injuriesLimited investigationFinal reportCessna 150M · Washington Cros, NJthe pilot-in-command's inadequate in-flight planning which resulted in a total loss of engine power due to fuel exhaustion.Apr 23, 1994 · N6101K · Substantial damageNTSB BFO94LA074Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Plymouth, MAThe pilot's failure to maintain adequate airspeed.Apr 23, 1994 · N2167 · Substantial damageNTSB BFO94FA073Accident · 4 fatalField investigationFinal reportBeech B24R · College Park, MDthe pilot's improper flare and delayed recovery from the bounced landing. Factors contributing to the accident were the pilot's failure to retract the landing gear during the aborted landing; the exceeded allowable gross weight; and the unfavorable wind…Apr 23, 1994 · N9353S · DestroyedNTSB ATL94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Athens, ALThe mechanic's failure to properly install an access plug which resulted in the loss of engine oil pressure.Apr 23, 1994 · N2945F · Substantial damageNTSB MIA94FA125Accident · 2 fatalField investigationFinal reportBell 47D1 · Marathon, FLSeparation of the tail rotor gearbox and tail rotor blades for an undetermined reason. Factors related to the accident were: failure of maintenance personnel to follow the proper maintenance procedure after a previous tail rotor strike, and failure to conduct…Apr 22, 1994 · N9660 · DestroyedNTSB LAX94LA215Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe cfi's improper level off during landing. The tailwind was a factor.Apr 22, 1994 · N2946E · Substantial damageNTSB LAX94LA199Accident · 1 fatalLimited investigationFinal reportContinental Copters Tomcat MK5A · Brawley, CAFailure of the pilot to maintain sufficient altitude, while maneuvering to land after completing aerial application. Factors related to the accident were: darkness and the lack of visual cues for the pilot to detect the obstruction (power line).Apr 22, 1994 · N9061T · Destroyed