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 FTW90FA037Accident · 2 fatalField investigationFinal reportChristen Industries Pitts S-2B · La Junta, TXThe pilot's delayed remedial action to recover from the spin and his misjudging of altitude.Nov 23, 1989 · N6031U · DestroyedNTSB FTW90FA031Accident · 3 fatalField investigationFinal reportCessna 210E · Matagorda 526The separation of the propeller system for unknown reasons. Contributing to the severity of the injuries was the pilot's failure to assure that a raft and/or lifevests were on the airplane during the overwater portion of the flight.Nov 23, 1989 · TGGUW · DestroyedNTSB CHI90LA032Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Howell, MIFailure of the mixture control cable, which resulted in a loss of power due to fuel starvation during a climb after takeoff. A factor related to the accident was: rough terrain in the emergency landing area.Nov 23, 1989 · N819CM · Substantial damageNTSB CHI90DET01Accident · No injuriesFinal reportPiper PA-24-250 · Decatur, INThe pilot's misjudgement of the fuel supply, inaccurate fuel consumption calculations, and his improper in-flight planning/decision, which resulted in fuel exhaustion. The lack of suitable terrain for an emergency landing was a related factor.Nov 23, 1989 · N5483P · Substantial damageNTSB MKC90LA036Accident · No injuriesLimited investigationFinal reportBurdette Cuby PA-11 · Ashland, KSAn undetermined problem with the fuel system, which resulted in a loss of engine power, and operation of the aircraft by the pilot with the known deficiency. The uneven (terraced) terrain was a contributing factor.Nov 22, 1989 · N99615 · Substantial damageNTSB MKC90LA033Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Richmond, MNImproper use of the fuel tank selector by the pilot and his improper use of emergency procedures, which resulted in fuel starvation after a fuel tank had emptied. Contributing factors were: inoperative fuel quantity gauges, pilot's operation with known…Nov 22, 1989 · N8074R · Substantial damageNTSB FTW90IA030Incident · No injuriesIncident investigationFinal reportSaab-Fairchild 340A · Beaumont, TXThe pilot failed to maintain adjusted vref and proper descent rates during the approach. The pilot delayed decision to execute a go-around and the copilot failed to monitor the poorly flown approach. Contributing to the accident was the rain and wind shear…Nov 22, 1989 · N363MA · Minor damageNTSB DEN90LA026Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Gillette, WYForced landing in unsuitable terrain as a result of an engine crankshaft failure at low level cruise flight.Nov 22, 1989 · N843YT · Substantial damageNTSB DEN90LA024Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Dove Creek, COImproper flare by the student pilot, his failure to maintain runway alignment, and a delay by the flight instructor (CFI) in initiating remedial action, which resulted in a loss of airspeed and a stall/mush after the aircraft drifted over a cultivated field…Nov 22, 1989 · N42699 · Substantial damageNTSB CHI90FA029Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Monroe Center, ILIn-flight fire initiated by an inadequately installed wiring harness and propagated by an existing fuel leak which was not repaired.Nov 22, 1989 · N9465W · DestroyedNTSB SEA90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bremerton, WAFuel exhaustion and inadequate preflight planning.Nov 21, 1989 · N63496 · DestroyedNTSB MIA90TF#01Accident · No injuriesClass 3Final reportCessna 552 · Pensacola, FLNov 21, 1989 · N12065 · Substantial damageNTSB MIA90LA030Accident · No injuriesLimited investigationFinal reportCessna 177RG · Mims, FLA worn throttle control assembly that had failed.Nov 21, 1989 · N7628V · Substantial damageNTSB ANC90T#A01Accident · No injuriesClass 3Final reportPiper PA-18-150 · Fairbanks, AKNov 21, 1989 · N54938 · Substantial damageNTSB FTW90LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Port Allen, LAFuel system contamination due to inadequate maintenance/service of the airplane.Nov 20, 1989 · N13055 · Substantial damageNTSB CHI90LA031Accident · No injuriesLimited investigationFinal reportHelio H-391B · Plainwell, MIFailure of the crosswind landing gear system to engage on the left main gear due to improper rigging adjustment by maintenance personnel. Factors related to the accident were: unfavorable wind conditions (gusts and quartering crosswind) and soft terrain in…Nov 20, 1989 · N8750R · Substantial damageNTSB CHI90LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe student pilot's inadequate compensation for wind conditions. Factors related to the accident were: inadequate supervision by the student's flight instructor (CFI), the student's failure to obtain weather information (use a preflight briefing service)…Nov 20, 1989 · N757UV · Substantial damageNTSB SEA90LA032Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Las Vegas, NVThe pilot of the raven RX7, N5710Y, failed to maintain adequate control to avoid a collision with the firefly 7, N4070W, and both pilots did not maintain adequate clearance from each other during the practice maneuver.Nov 19, 1989 · N4070W · 2 aircraft · Substantial damageNTSB SEA90FA019Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Vancouver, WAThe pilot in command's inadequate preflight planning, pilot's attempted VFR flight into IMC conditions and the pilot's lack of instrument qualifications. Contributing to the accident was the low ceiling, fog and the pilot's lack of recent experience.Nov 19, 1989 · N8289P · DestroyedNTSB LAX90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hayward, CAInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Collision with a vehicle in the emergency landing area contributed to the damage and injuries.Nov 19, 1989 · N4359C · Substantial damageNTSB CHI90LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Detroit, MIInadequate preflight planning/preparation which resulted in fuel exhaustion due to an inadequate supply of fuel.Nov 19, 1989 · N66714 · Substantial damageNTSB BFO90LA013Accident · No injuriesLimited investigationFinal reportCessna 172 · Mitchellville, MDThe pilot allowed the aircraft to enter an inadvertent porpoise during an aborted takeoff.Nov 19, 1989 · N52491 · Substantial damageNTSB ATL90LA029Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Burlington, NCLoss of engine power for an unknown reason. The barn was considered to be a related factor.Nov 19, 1989 · N89212 · Substantial damageNTSB SEA90LA018Accident · No injuriesLimited investigationFinal reportCessna 140 · Amboy, WALoss of engine power due to carburetor icing.Nov 18, 1989 · N2070V · DestroyedNTSB SEA90LA017Accident · No injuriesLimited investigationFinal reportErcoupe 415D · Vancouver, WAThe pilot's inadvertant leaning of the fuel mixture to near idle cutoff, causing the engine to quit.Nov 18, 1989 · N3354H · Substantial damageNTSB MKC90LA031Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Osage City, KSThe pilot misjudged distance and altitude to the runway while on final approach to land. Factors related to the accident were: dark night and static wires.Nov 18, 1989 · N20428 · Substantial damageNTSB MKC90FA032Accident · No injuriesField investigationFinal reportBeech 95-B55B · Lakeville, MNInadequate visual lookout by the pilot in command in both aircraft.Nov 18, 1989 · N5678K · 2 aircraft · Substantial damageNTSB MIA90LA029Accident · No injuriesLimited investigationFinal reportBeech 58 · Fernandina Bch, FLFailure of the pilot to perform the emergency gear extension procedure to assure that the gear was down and locked. Factors related to the accident were: low oil pressure in the right eng, failure of both voltage regulators, and the low level of charge in the…Nov 18, 1989 · N6659D · Substantial damageNTSB LAX90LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Rancho Calif, CAThe pilot's loss of directional control during a crosswind landing.Nov 18, 1989 · N1963H · Substantial damageNTSB LAX90LA037Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Reedley, CAPilot's improper recovery from a bounce landing.Nov 18, 1989 · N3551R · Substantial damageNTSB LAX90DVG02Accident · No injuriesFinal reportSchweizer G-164B · Knights Landing, CAThe failure of the right main Landing gear due to a sheared bolt that attached the spring leg to the gear.Nov 18, 1989 · N6977K · Substantial damageNTSB CHI90LA039Accident · No injuriesLimited investigationFinal reportBeech V35B · Momence, ILGradual total failure of the powerplant due to oil exhaustion during a night cross country operation, and the subsequent gear-up forced landing on a frozen field.Nov 18, 1989 · N1809W · Substantial damageNTSB ATL90LA028Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Georgetown, SCThe student pilot's failure to maintain directional control during landing. A factor was the student's lack of recent experience.Nov 18, 1989 · N1253X · Substantial damageNTSB ANC90LA013Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Heiden, AKThe pilot's inadequate preflight preparation and failure to identify suitable terrain for takeoff.Nov 18, 1989 · N3654C · Substantial damageNTSB MIA90WA028Accident · No injuriesForeign investigationCessna 310K · Providenciales, Turks & Caicos IslandsNov 17, 1989 · N707DL · Substantial damageNTSB LAX90LAMS1Accident · 1 fatalFinal reportCessna U206E · Pacific Ocean (Pacific Ocean)Undetermined.Nov 17, 1989 · N9423G · DestroyedNTSB LAX90LA035Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Van Nuys, CAThe incorrect installation of the engine cowl and baffle seals during the installation of the engine following an overhaul.Nov 17, 1989 · N2069Q · Substantial damageNTSB LAX90LA033Accident · 1 fatalLimited investigationFinal reportMcDonnell Douglas 369 · Barstow, CAImproper planning/decision by the pilot, and his delay in jettisoning the load.Nov 17, 1989 · N1097G · DestroyedNTSB LAX90LA032Accident · No injuriesLimited investigationFinal reportMooney 201 · Concord, CAThe pilot's loss of directional control and subsequent collision with an object during a touch and go landing in visual meteorological conditions.Nov 17, 1989 · N201VW · Substantial damageNTSB NYC90FA030Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · New Castle, NYThe pilot failed to maintain proper altitude and alignment with the ILS during the ILS approach and failed to perform the missed approach.Nov 16, 1989 · N55399 · DestroyedNTSB LAX90DVG01Accident · No injuriesFinal reportSchweizer G-164B · Grimes, CAFailure of the counter weight bracket to the propeller assembly.Nov 16, 1989 · N3633Q · Substantial damageNTSB FTW90LA028Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Mineral Wells, TXThe landing gear was either not fully extended during the landing or it retracted during the landing roll for an undetermined reason.Nov 16, 1989 · N422K · Substantial damageNTSB SEA90LA016Accident · 1 fatalLimited investigationFinal reportHughes 269C · Estacada, ORThe pilot misjudged clearance between her external load and the obstruction. Factors related to the accident were: the obstruction, improper maintenance and modification of the external load line/hook by the operator, failure of the pilot to jettison the…Nov 15, 1989 · N9592F · DestroyedNTSB NYC90FA029Accident · 2 fatalField investigationFinal reportHughes 369HS · North Adams, MAFailure of the pilot-in-command (PIC) to assure proper rotor RPM and proper operation of the flight controls during an approach in gusty wind conditions. A factor related to the accident was: the pic's lack of experience in the type of operation.Nov 15, 1989 · N9208F · DestroyedNTSB MIA90FA027Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Pembroke Pines, FLInadequate annual inspection by other maintenance personnel and inadequate preflight inspection by the pilot, which resulted in failure to detect water and contamination (residue) in the fuel. Contributing factors were: failure of the plt to feather the…Nov 15, 1989 · N15LH · DestroyedNTSB FTW90LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · Norman, OKThe pilot inadvertently became lost and disoriented and delayed in obtaining help from the flight service station, which resulted in fuel exhaustion.Nov 15, 1989 · N9258U · DestroyedNTSB FTW90FA033Accident · 2 fatalField investigationFinal reportCessna 182P · Slidell, LAThe pilot's initiation of the flight into known adverse weather conditions which resulted in spatial disorientation and his failure to maintain sufficient altitude over the water. Factors were: darkness and the adverse weather conditions that prevailed.Nov 15, 1989 · N7351N · DestroyedNTSB CHI90FA026Accident · 1 fatalField investigationFinal reportCessna 172D · Mt Morris, ILVFR flight into IMC and spatial disorientation of the pilot. Contributing to the accident were the meteorological conditions and the overconfidence and lack of experience of the pilot.Nov 15, 1989 · N2796U · DestroyedNTSB CHI90FA028Accident · 3 fatalField investigationFinal reportBeech A36 · Shell Lake, WIThe pilot-in-command's failure to perform a missed approach, his descending below the minimum descent altitude, and his failure to maintain proper altitude to avoid impact with the terrain. Contributing to the accident was the pilot-in-command's lack of total…Nov 14, 1989 · N1607W · DestroyedNTSB BFO90LA011Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Wilmington, DEA loss of engine power as a result of the student pilot inadvertently pulling the mixture control to the idle cut-off position, and the flight instructor's inadequate supervision. A contributing factor to the accident was the rough and uneven terrain.Nov 14, 1989 · N8627J · Substantial damage