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 FTW98FA156Accident · 2 fatalField investigationFinal reportBell 206-A · Rio Hondo, TXThe engine compartment fire due to undetermined reasons, which resulted in the in-flight separation of the tailboom.Mar 24, 1998 · TGJET · DestroyedNTSB DCA98WA034Incident · No injuriesForeign investigationBoeing 737 · Piura, PeruMar 24, 1998 · UNKNTSB ANC98LA030Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKThe pilot's inadequate compensation for crosswind conditions during landing. A factor was the crosswind.Mar 24, 1998 · N1987U · Substantial damageNTSB SEA98LA049Accident · No injuriesLimited investigationFinal reportCessna 177A · Laurel, MTThe pilot's excessive descent rate on final, and improper recovery from a bounced landing.Mar 23, 1998 · N177MT · Substantial damageNTSB MIA98WA106Accident · 5 fatalForeign investigationCessna T207A · Toqui, VenezuelaMar 23, 1998 · N2557P · DestroyedNTSB MIA98LA107Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Dauphin Island, ALFailure of the pilot-in-command (CFI) to maintain directional control of the airplane following an intentional low altitude maneuver by the student. Also, altitude inadequate for recovery from the in-flight loss of control.Mar 23, 1998 · N24543 · Substantial damageNTSB LAX98LA120Accident · No injuriesLimited investigationFinal reportBeech C35 · Rio Linda, CAthe pilot's inadequate fuel management which led to fuel exhaustion.Mar 23, 1998 · N8948A · Substantial damageNTSB LAX98GA127Accident · 4 fatalFinal reportBell 205A-1 · Los Angeles, CAAn excessive bending load applied to the tail rotor blade assembly of an undetermined origin which produced a fatigue crack, the separation of the assembly, and a forced landing. Factors were the lack of suitable terrain to perform a forced landing, the…Mar 23, 1998 · N90230 · DestroyedNTSB CHI98LA108Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Steele, MOthe pilot failed to maintain an adequate visual lookout. A factor was the pile of gravel in the taxiway.Mar 23, 1998 · N1524H · Substantial damageNTSB SEA98LA050Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Seattle, WALoss of engine power due to a restricted fuel system filter.Mar 22, 1998 · N5245P · Substantial damageNTSB NYC98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Weyers Cave, VAthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control of the airplane during the landing roll, which resulted in an encounter with a fence on uneven terrain and a nose over.Mar 22, 1998 · N80512 · Substantial damageNTSB MIA98WA102Accident · 6 fatalForeign investigationBeech 95-B55 · North Eleuthera, BahamasMar 22, 1998 · N4314Y · DestroyedNTSB MIA98LA104Accident · No injuriesLimited investigationFinal reportCessna 172I · Kinston, NCthe pilot's inadequate preflight and improper fuel management, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Soft terrain in the emergency landing area was a related factor.Mar 22, 1998 · N35326 · Substantial damageNTSB MIA98LA103Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Tampa, FLfailure of the student pilot to maintain directional control of the airplane and proper runway alignment, which result in an in-flight collision with a hangar.Mar 22, 1998 · N2321D · Substantial damageNTSB FTW98LA154Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tulsa, OKThe complete loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Mar 22, 1998 · N9940L · Substantial damageNTSB ATL98FA059Accident · Serious injuriesField investigationFinal reportPiper PA-31-310 · Southport, NCThe pilot's failure to follow the preflight checklist, which resulted in a loss of engine power due to fuel starvation. Contributing to the significance of the accident was the pilot's failure to maintain control of the aircraft following the loss of engine…Mar 22, 1998 · N715PM · DestroyedNTSB LAX98LA126Accident · No injuriesLimited investigationFinal reportVictor Marsh Marsh 1 · Lone Pine, CAThe pilot's improper in-flight planning, misjudged terrain clearance, and failure to attain adequate altitude before attempting to traverse the mountain pass. Contributing factors were the high density altitude and the rising, mountainous terrain.Mar 21, 1998 · N166VP · Substantial damageNTSB FTW98LA155Accident · Minor injuriesLimited investigationFinal reportZito ZMI-A · Ogden, UTthe improper placement of lead ballast by the pilot, resulting in an improper balance of the airplane; and the pilot's excessive control input to correct a nose high attitude, resulting in ground impact.Mar 21, 1998 · N669Z · Substantial damageNTSB FTW98LA153Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Lancaster, TXThe pilot's failure to extend the landing gear.Mar 21, 1998 · N80556 · Substantial damageNTSB CHI98LA111Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Jeffersonville, INthe pilot's failure to maintain directional control. The crosswind was a factor.Mar 21, 1998 · N2648K · Substantial damageNTSB CHI98FA107Accident · 4 fatalField investigationFinal reportBeech A-36 · New Lebanon, INThe pilot's flight into known icing conditions. Contributing factors were the degraded aircraft performance, the pilot's inability to maintain the proper descent rate, trees, and the dark night condition.Mar 21, 1998 · N1812A · DestroyedNTSB CHI98FA106Accident · 6 fatalField investigationFinal reportCessna U206G · Grain Valley, MOPilot's inadequate preflight, the partial loss of oil and the resulting rod failure. A factor was the pilot's failure to maintain flying speed.Mar 21, 1998 · N506SD · DestroyedNTSB ANC98LA028Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot-in-command's decision to relinquish controls to the student pilot in the left seat during practice landings, and the pilot-in-command's failure to maintain directional control. A factor contributing to this accident was the pilot-in-command's lack…Mar 21, 1998 · N3179B · Substantial damageNTSB ANC98LA027Accident · No injuriesLimited investigationFinal reportCessna A185F · Homer, AKThe pilot's failure to maintain directional control. Factors in the accident are the sheared valve stem/deflation of the tire, and subsequent fracturing of the associated wheel.Mar 21, 1998 · N9620Q · Substantial damageNTSB NYC98WA080Accident · Serious injuriesForeign investigationPiper PA23-250 · Newfoundland, CanadaMar 20, 1998 · N456MR · DestroyedNTSB NYC98LA079Accident · No injuriesLimited investigationFinal reportEnstrom F280F · New Alexandria, PAA bird strike.Mar 20, 1998 · N66JV · Substantial damageNTSB LAX98TA123Accident · No injuriesFinal reportBell 206B · Santa Clarita, CAThe failure of the pilot to maintain adequate clearance with the wires. Additional factors in this accident are the position of the sun at that time of the day, which made it difficult to see the wires, and the lack of markings or poles for that series of…Mar 20, 1998 · N3186L · Substantial damageNTSB LAX98FA118Accident · 3 fatalField investigationFinal reportCessna 310H · Corona, CAThe failure of both pilots to maintain an adequate visual lookout and to see and avoid the other airplane.Mar 20, 1998 · N310RR · 2 aircraft · DestroyedNTSB SEA98FA047Accident · No injuriesField investigationFinal reportAerospatiale SN-601 · Portland, ORThe pilot-in-command's decision to attempt takeoff with the right engine inoperative, resulting in his failure to maintain directional control or attain adequate airspeed during the takeoff attempt. Factors included a fractured right engine starter-generator…Mar 19, 1998 · N600RA · Substantial damageNTSB LAX98LA124Accident · No injuriesLimited investigationFinal reportCessna 210K · Fallon, NVThe aircraft owner/pilot's improper assembly of the engine oil pump, which resulted in failure of the unit and oil starvation failure of the engine. A factor was the lack of supervision of the owner/pilot's work by the A & P mechanic.Mar 19, 1998 · N8274M · Substantial damageNTSB LAX98LA122Accident · No injuriesLimited investigationFinal reportCessna TU206F · Avalon, CAContamination of the fuel system which led to a loss of engine power. Factors were the lack of suitable terrain for the forced landing and the barbwire fence.Mar 19, 1998 · N9674G · Substantial damageNTSB LAX98LA116Accident · No injuriesLimited investigationFinal reportAyres S2R · Willows, CAThe pilot's failure to maintain adequate altitude/clearance from the wires.Mar 19, 1998 · N32064 · Substantial damageNTSB FTW98TA152Accident · Serious injuriesFinal reportBell OH-58C · Dulce, NMThe partial loss of engine power due to a disconnected bleed air line to the fuel controller and the unsuitable terrain for a forced landing. Factors were the loose B-nut, the inadequate maintenance by unknown personnel, insufficient standards/requirements…Mar 19, 1998 · N505JA · Substantial damageNTSB FTW98FA151Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Mcgehee, ARThe pilot's inadvertent flight into adverse weather conditions resulting in the loss of control due to spatial disorientation. Factors were the fog and low ceiling, and the inadequate flight instruments available to the pilot.Mar 19, 1998 · N10035 · DestroyedNTSB LAX98LA131Accident · No injuriesLimited investigationFinal reportCallair A-9 · Thermal, CAThe failure of the oil pump drive shaft due to the installation of an incorrect oil pump crankshaft gear by maintenance personnel at the last overhaul.Mar 18, 1998 · N7211V · Substantial damageNTSB LAX98LA121Accident · No injuriesLimited investigationFinal reportCessna 421B · Show Low, AZThe pilot's failure to attain the proper alignment on the runway due to the obscuration by snow of the runway and on the airplane's windows.Mar 18, 1998 · N70PD · Substantial damageNTSB DCA98RA030Accident · 13 fatalForeign investigationSaab-Scania 340 · Taipai, TaiwanMar 18, 1998 · UNKNTSB NYC98LA078Accident · No injuriesLimited investigationFinal reportCessna 150 · Lockport, NYThe pilot's misjudgment of altitude and distance during a forced landing in the traffic pattern. A factor in the accident was the carburetor icing conditions.Mar 17, 1998 · N704GP · Substantial damageNTSB LAX98FA119Accident · Minor injuriesField investigationFinal reportBeech A35 · Auburn, CAfailure of the engine driven fuel pump drive coupling and the pilot's failure to perform the emergency procedure specified in the Pilot Operating Handbook.Mar 17, 1998 · N8597A · Substantial damageNTSB DCA98WA049Incident · No injuriesForeign investigationBoeing 757 · Brazil, BrazilMar 17, 1998 · UNK · No damageNTSB LAX98LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA34-200 · Van Nuys, CAThe pilot's misjudged landing flare which led to an uncontrolled porpoise and eventual collapse of the landing gear.Mar 16, 1998 · N4442T · Substantial damageNTSB CHI98LA103Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Council Bluffs, IAthe pilot's failure to maintain proper runway alignment during the landing. The dark night was a factor.Mar 16, 1998 · N1521T · Substantial damageNTSB LAX98LA115Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · San Luis Obispo, CAThe student pilot's inadvertent pulling of the mixture, instead of the carburetor heat, while preparing for the approach, and the flight instructor's inadequate supervision.Mar 15, 1998 · N4079M · Substantial damageNTSB LAX98FA113Accident · 4 fatalField investigationFinal reportBeech B95A · Little River, CAthe pilot's inadvertent visual flight into instrument meteorological conditions. Contributing to the accident was the pilot's improper weather evaluation.Mar 15, 1998 · N569T · DestroyedNTSB IAD98LA038Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Castlewood, VAThe pilot's failure to achieve the proper touchdown point and the delayed execution of the go around. A contributing factor was the fence.Mar 15, 1998 · N7507F · Substantial damageNTSB IAD98FA037Accident · 1 fatalField investigationFinal reportCessna 152 · West Mifflin, PAThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin. A related factor was the pilot's impairment due to the use of drugs.Mar 15, 1998 · N67893 · DestroyedNTSB ATL98LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · La Belle, FLthe student pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. The gusty crosswind condition was a related factor.Mar 15, 1998 · N49551 · Substantial damageNTSB ATL98LA057Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Chamblee, GAthe pilot's inadequate compensation for wind conditions and excessive application of braking action, which resulted in an on-ground loss-of-control and a nose over. Related factors were: the pilot's selection of the wrong runway, and the crosswind condition.Mar 15, 1998 · N63538 · Substantial damageNTSB SEA98LA046Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mcminnville, ORDisconnection of the throttle cable at the throttle-to-carburetor adapter plate and the failure of the student pilot to shut the aircraft's engine down once a safe landing was assured. Factors contributing to the accident were the soft terrain and overloading…Mar 14, 1998 · N757CZ · Substantial damageNTSB LAX98LA114Accident · Minor injuriesLimited investigationFinal reportSocata TBM 700 · Truckee, CAThe failure of the pilot to maintain control of the aircraft due to spatial disorientation. A factor was the dark night.Mar 14, 1998 · N345RD · Destroyed