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 SEA91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Auburn, WAAn improper fuel selector valve handle, improper selection of the fuel selector position, and the pilot's lack of understanding of the fuel selector position.Apr 20, 1991 · N1567Z · Substantial damageNTSB SEA91FA089Accident · 2 fatalField investigationFinal reportCessna 150L · Mount Vernon, WAThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin at low altitude. His lack of experience was a related factor.Apr 20, 1991 · N16230 · DestroyedNTSB NYC91DNA02Accident · Minor injuriesFinal reportBell 47-G3B1 · Harwich, MAA failure of the clutch during takeoff due to improper maintenance procedures. Factors related to the accident were insufficient altitude to establish an autorotation.Apr 20, 1991 · N1166W · Substantial damageNTSB LAX91LA182Accident · Serious injuriesLimited investigationFinal reportRobinson R22-BETA · Phoenix, AZThe pilot's failure to maintain main rotor RPM. Factor contributing to the accident was the pilot's inadequate in-flight planning.Apr 20, 1991 · N4066J · Substantial damageNTSB FTW91LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Huntsville, TXThe pilot's failure to maintain directional control of the airplane. A factor was the emphasis placed upon full-stall landings by his instructor.Apr 20, 1991 · N5536E · Substantial damageNTSB CHI91LA136Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grayslake, ILThe instructor's inadequate compensation for wind conditions. Factors were the wind gusts and the instructor's failure to maintain airspeed.Apr 20, 1991 · N4VT · Substantial damageNTSB CHI91DCJ02Accident · No injuriesFinal reportFagerberg Longeze · Wahoo, NEThe improper installation/maintenance of the carburetor heat control. A factor was the pilot's restricted visual outlook.Apr 20, 1991 · N459EZ · Substantial damageNTSB ATL91LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Elberta, ALThe pilot's failure to apply carburetor heat. Factors were weather conditions for the formation of induction ice, and the soft terrain.Apr 20, 1991 · N7202E · Substantial damageNTSB ATL91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bessemer, ALRupture of a high-time, rubber, oil cooler hose, which resulted in a loss of engine oil, oil exhaustion, and seizure of the engine.Apr 20, 1991 · N503G · Substantial damageNTSB ATL91FA084Accident · 2 fatalField investigationFinal reportCessna 172N · Dunlap, TNThe pilot-in-command's inadequate preflight planning/preparation, his attempted VFR flight into IFR conditions, and his subsequent failure to maintain a proper altitude. Factors in the accident were: the mountainous terrain, the foggy, low ceiling conditions…Apr 20, 1991 · N5738J · DestroyedNTSB SEA91LA088Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Clark Fork, IDThe pilot-in-command's failure to maintain proper altitude in cruise light resulting in an in flight collision with a wire and subsequent forced landing in a river.Apr 19, 1991 · N45656 · DestroyedNTSB NYC91LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Bloomvale, NYThe pilot's delay in aborting the takeoff.Apr 19, 1991 · N12236 · Substantial damageNTSB LAX91LA180Accident · Serious injuriesLimited investigationFinal reportTownsend Executive · Redding, CAThe failure of the pilot to maintain control of the helicopter. A factor in the accident was the pilot's lack of total experience in helicopters.Apr 19, 1991 · N7135X · Substantial damageNTSB DEN91LA062Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Santa Rosa, NMThe pilot of the other aircraft failed to maintain clearance between the aircraft.Apr 19, 1991 · N87259 · 2 aircraft · Substantial damageNTSB DEN91FA061Accident · Serious injuriesField investigationFinal reportCessna T210M · Littleton, COImproper reassembly of the overhauled turbocharger by maintenance personnel, and the pilot's improper use of the mixture control and boost pump. Factors related to the accident were: the adverse weather conditions and unsuitable terrain in the emergency…Apr 19, 1991 · N761CM · DestroyedNTSB CHI91DER03Accident · 1 fatalFinal reportVarieze 001 · Superior, WIThe pilot's poor planning and decision making which resulted in a loss of engine power due to fuel exhaustion.Apr 19, 1991 · N87VE · DestroyedNTSB ATL91LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150J · New Bern, NCThe aircraft engine loss of power for an undetermined reason. Factors related to the accident were the dark night, and the inadvertent stall of the aircraft.Apr 19, 1991 · N51414 · Substantial damageNTSB NYC91LA118Accident · No injuriesLimited investigationFinal reportCessna P210 · Olean, NYImproper flare by the pilot, which resulted in a hard landing. Factors related to the accident were: the pilot's lack of recent experience and the unfavorable wind condition.Apr 18, 1991 · N90TL · Substantial damageNTSB CHI91DEM04Accident · No injuriesFinal reportFred B. Stencel Falcon X P · St. Charles, MIA result of the pilot in command not maintaining directional control during the go around maneuver. Factors associated with the accident were the pilot in command's lack of total experience and familiarity with the airplane.Apr 18, 1991 · N747AA · DestroyedNTSB CHI91DEE04Accident · No injuriesFinal reportBeech 35-A33 · Vernon Hills, ILWater contamination of the fuel, and the pilot's inadequate preflight inspection.Apr 18, 1991 · N123JB · Substantial damageNTSB SEA91LA086Accident · No injuriesLimited investigationFinal reportGrumman G-21A · Spokane, WAThe pilot-in-command did not maintain directional control of the airplane. Factors were: the pic's inadequate compensate for the wind, his limited flight expereince in this type of airplane, and the check airman's poor supervision.Apr 17, 1991 · N9750Z · Substantial damageNTSB FTW91LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Port Lavaca, TXThe pilot's inadvertent stall at an altitude too low for recovery. A factor was the pilot's low pass.Apr 17, 1991 · N4695Y · DestroyedNTSB CHI91DCG02Accident · Serious injuriesFinal reportHuff Pulsar · Missouri City, MOOil fouled spark plugs resulting in a partial loss of engine power. Soft terrain in the forced landing area was a factor.Apr 17, 1991 · N89PB · Substantial damageNTSB SEA91LA087Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Coeur D'Alene, IDThe pilot's misjudgement of his aircraft's climb capability when flying towards rising terrain. Factors include his lack of familiarity with the geographic area.Apr 16, 1991 · CFBET · Substantial damageNTSB NYC91LA117Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Whitefield, NHInadequate compensation for wind conditions by the pilot which resulted in a loss of directional control. A factor contributing to the accident was the gusty wind conditions.Apr 16, 1991 · N1303E · Substantial damageNTSB MIA91FA124Accident · Serious injuriesField investigationFinal reportCessna 152 · Oak Meadows, FLThe failure of the instructor pilot to maintain an airspeed above stall speed resulting in an inadvertent stall at an altitude that precluded recovery. Contributing to the accident was the instructor pilot's poor judgement and ostentatious display at a low…Apr 16, 1991 · N4902H · Substantial damageNTSB MIA91FA123Accident · 3 fatalField investigationFinal reportWaco ASO · Lake Apopka, FLAn inadvertent stall and spin at an altitude that precluded recovery.Apr 16, 1991 · NC7091 · DestroyedNTSB LAX91LA175Accident · Serious injuriesLimited investigationFinal reportSnider RV6 · Paulden, AZThe pilot's poor preflight preparation and his failure to ensure that the fuel selector was properly positioned for flight.Apr 16, 1991 · N2165U · Substantial damageNTSB FTW91LA067Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Carlisle, ARThe pilot's failure to maintain airspeed above the stalling speed of the airplane and the resultant inadvertent stall. A factor was the emotional state of the pilot.Apr 16, 1991 · N8188A · Substantial damageNTSB FTW91LA066Accident · 2 fatalLimited investigationFinal reportAeronca 7AC · Bradley, ARThe pilot's attempted to perform aerobatic flight at an altitude inadequate for recovery.Apr 16, 1991 · N1599E · DestroyedNTSB CHI91LA134Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDInadequate visual outlook by the pilot in command.Apr 16, 1991 · N143ND · 2 aircraft · Substantial damageNTSB SEA91LA260Accident · 1 fatalLimited investigationFinal reportAero Commander S-2R · Grangeville, IDThe improper decision by the pilot to continue VFR flight in IMC weather conditions in mountainous terrain, resulting in pilot disorientation and inadvertent flight into a box canyon. Factors relating to the accident were the rain showers and low ceiling…Apr 15, 1991 · N5539X · DestroyedNTSB MIA91LA122Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Clewiston, FLDisintegration of the impeller for undetermined reasons resulting in the total loss of engine power necessitating the forced landing.Apr 15, 1991 · N8386K · Substantial damageNTSB LAX91LA179Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Piru, CA1) The pilot failing to maintain visual lookout, and 2) inflight collision with unmarked transmission wires.Apr 15, 1991 · N4030A · DestroyedNTSB LAX91LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA22-150 · Las Vegas, NVThat the pilot improperly selected the fuel tank that did not contain any fuel and his subsequent failure to maintain airspeed.Apr 15, 1991 · N4416A · Substantial damageNTSB FTW91LA065Accident · No injuriesLimited investigationFinal reportCessna 172N · Weatherford, OKThe inadvertent stalling of the airplane. A factor was the gusty wind.Apr 15, 1991 · N75759 · Substantial damageNTSB CHI91LA133Accident · No injuriesLimited investigationFinal reportCessna TR182 · Jackson, MIFailure to the pilot to assure gear extension. Factors related to the accident were the electrical failure due to a seized alternator and diverted attention by the pilot.Apr 15, 1991 · N4359R · Substantial damageNTSB NYC91LA113Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Pleasant Valley, NYThe failure of the pilot of N5232K to maintain visual contact and separation with N9763U.Apr 14, 1991 · N9763U · 2 aircraft · DestroyedNTSB LAX91LA176Accident · Serious injuriesLimited investigationFinal reportGrumman AA-LC · Inyokern, CAPoor flight planning by the pilot-in-command which resulted in a total loss of engine power due to fuel exhaustion.Apr 14, 1991 · N31DV · Substantial damageNTSB SEA91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ekalaka, MTThe pilot did not maintain directional control of the airplane during the landing roll. Factors to the accident were: the landing surface was covered with slush, snow was falling and obscured the pilot's vision.Apr 13, 1991 · N1322A · Substantial damageNTSB SEA91LA084Accident · No injuriesLimited investigationFinal reportCessna C-172N · Ellensburg, WAThe improper maintenance inspection of the airccraft. A factor relating to the accident was a ditch in the ladning area.Apr 13, 1991 · N75646 · Substantial damageNTSB NYC91FA112Accident · 1 fatalField investigationFinal reportPiper PA-30 · Hollidaysburg, PAThe pilot's loss of control for undetermined reasons.Apr 13, 1991 · N8073Y · DestroyedNTSB ATL91LA081Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Whiteville, NCCarburetor ice due to the pilot's failure to use carburetor heat.Apr 13, 1991 · N7919F · Substantial damageNTSB ATL91LA080Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Saluda, SCThe flight instructor did not maintain the proper altitude during the simulated forced landing.Apr 13, 1991 · N1960Q · Substantial damageNTSB ANC91LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Cantwell, AKThe pilot in command's poor preflight planning/preparation. A factor in the accident was the snow covered runway.Apr 13, 1991 · N3031U · Substantial damageNTSB SEA91LA083Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Port Orchard, WAThe loss of engine power due to contaminated fuel system.Apr 12, 1991 · N85948 · Substantial damageNTSB NYC91LA114Accident · No injuriesLimited investigationFinal reportCessna 150L · Montgomery, NYThe pilot's inadvertent exit (falling) from the airplane, while attempting to recover an object from outside the airplane without setting the parking brake and/or shutting down the engine.Apr 12, 1991 · N9913G · Substantial damageNTSB LAX91LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Madera, CAThat the pilot's fuel consumption calculation were inaccurate. Contributing to this accident was fuel exhaustion.Apr 12, 1991 · N7290E · Substantial damageNTSB CHI91LA132Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fibre, MIThe pilot attempting to taxi on unsuitable terrain.Apr 12, 1991 · CGWGZ · Substantial damageNTSB CHI91LA131Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Grand Ledge, MIThe student's failure to maintain a proper altitude and clearance from the terrain along with the cfi's failure to adequately supervise the student's actions. A factor contributing to the accident was the inadequate visual lookout available due to the night…Apr 12, 1991 · N294Q · Substantial damage