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 ANC00LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Seward, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were a crosswind, and a downdraft.Oct 19, 1999 · N8918Y · Substantial damageNTSB NYC00WA015Accident · 1 fatalForeign investigationPiper PA-46-350P · Cranbrook, CanadaOct 18, 1999 · N90D · DestroyedNTSB MIA00LA010Accident · No injuriesLimited investigationFinal reportCessna 150M · Bunnell, FLThe erosion and separation of the aft end plate P/N 0450338-18 of the right muffler resulting in exhaust gas contact to electrical wires in the engine compartment. Also, unsuitable terrain encountered by the pilot during the forced landing. A finding in the…Oct 18, 1999 · N3240V · Substantial damageNTSB LAX00LA016Accident · Minor injuriesLimited investigationFinal reportBell 206-B3 · Soda Springs, CAThe failure of the pilot-in-command to maintain landing skid clearance during hover taxi, which resulted in a dynamic rollover.Oct 18, 1999 · N2296N · Substantial damageNTSB FTW00WA020Accident · 3 fatalForeign investigationCessna 182P · Coban, GuatemalaOct 18, 1999 · TGROF · DestroyedNTSB DEN00FA007Accident · 1 fatalField investigationFinal reportGardner Varieze · Quemado, NMThe pilot's selection of an unsuitable landing area on which to make a precautionary landing, and his excessive airspeed during landing touchdown. Factors were the ingestion of the foam air filter into the throat of the injector, and the pilot's failure to…Oct 18, 1999 · N13WM · Substantial damageNTSB MIA00LA009Accident · Minor injuriesLimited investigationFinal reportCessna A185E · Lake Wales, FLThe partial loss of engine power due to the inadequate annual inspection of the airplane by the mechanic with IA for his failure to assure that the mixture control cable jam nut at the rod end was secured following the reported adjustment by the airplane…Oct 17, 1999 · N85PR · Substantial damageNTSB MIA00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Bayou La Batre, ALThe pilot's improper preflight fuel planning and the his improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion.Oct 17, 1999 · N6504L · Substantial damageNTSB MIA00LA005Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Sunny Isles, FLA loss of engine power while maneuvering due to improper ignition timing by unknown person(s) resulting in an emergency descent and collision with the water.Oct 17, 1999 · N83574 · Substantial damageNTSB LAX00LA011Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Jean, NVThe pilot of the other airplane's failure to maintain an adequate visual lookout while taxiing for departure. Factors in the accident were: the narrow nature of the taxiway and the pilot of the other airplane's subsequent inability to S-turn for better…Oct 17, 1999 · N32186 · 2 aircraft · Minor damageNTSB LAX00LA010Accident · No injuriesLimited investigationFinal reportMintz Vari EZE · Jean, NVThe failure of the engine cylinder head due to detonation and subsequent over temperature for undetermined reasons.Oct 17, 1999 · N86KM · Substantial damageNTSB DCA00RA002Accident · Minor injuriesForeign investigationMcDonnell Douglas MD-11F · Subic Bay, PhilippinesOct 17, 1999 · N581FENTSB SEA00LA002Accident · No injuriesLimited investigationFinal reportBeech F33A · Idaho Falls, IDThe pilot's failure to adequately compensate for wind conditions. Factors include gusty, turbulent, variable crosswinds, and a fence in the vicinity of the runway.Oct 16, 1999 · N95CF · Substantial damageNTSB NYC00LA027Accident · No injuriesLimited investigationFinal reportKolb Firestar · London, KYThe student pilot's inability to maintain control of the airplane after inadvertently allowing it to become airborne. A factor in the accident was his lack of total aviation experience.Oct 16, 1999 · UNREG · Substantial damageNTSB MIA00LA012Accident · No injuriesLimited investigationFinal reportBeech D35 · Indiantown, FLThe reported unauthorized use of the airplane by an unknown person.Oct 16, 1999 · N2109D · Substantial damageNTSB MIA00LA008Accident · 2 fatalLimited investigationFinal reportEddie A. Smith KR-2 · Bell Buckle, TNThe poor in-flight planning decision by the pilot-in-command for continuing the flight with inadequate fuel supply and the inadvertent stall by the pilot-in-command following total loss of engine power due to fuel exhaustion. Findings in the accident were the…Oct 16, 1999 · N85ES · DestroyedNTSB LAX00LA022Accident · No injuriesLimited investigationFinal reportCessna 210 · Enterprise, NVThe failure of the pilot to maintain directional control of the aircraft during the landing roll, which resulted in a collision with a ditch.Oct 16, 1999 · N6556X · Substantial damageNTSB LAX00LA018Accident · 1 fatalLimited investigationFinal reportSikorsky CH-54A · Elko, NVthe flight engineer's decision to climb a step ladder that put him in close proximity to the still turning main rotor blades. The gusting wind was a factor in the accident.Oct 16, 1999 · N9125M · No damageNTSB LAX00FA017Accident · 2 fatalField investigationFinal reportCessna 152 · Ventura, CAthe pilot's continued VFR flight into IMC. Contributing factors were the pilot's self induced pressure to depart the airport before the weather worsened and the airport closed, and the mountain obscurement and foggy weather conditions, and the night light…Oct 16, 1999 · N5169B · DestroyedNTSB IAD00LA001Accident · No injuriesLimited investigationFinal reportCessna 182S · Staatsburg, NYwas the pilot's encounter with an unseen embankment while maneuvering to avoid a deer on the runway.Oct 16, 1999 · N783WW · Substantial damageNTSB ANC00LA006Accident · No injuriesLimited investigationFinal reportPiper PA-31-T3 · Gambell, AKAn in-flight collision with a bird.Oct 16, 1999 · N220CS · Substantial damageNTSB MIA00LA007Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lebanon, TNThe inadequate annual inspection of the airplane by the mechanic for his failure to note that the threaded portion of the bail wire had 2 1/2 failed threads which resulted in the inability to keep the gascolator bowl tightly secured. Also his failure to note…Oct 15, 1999 · N3013C · Substantial damageNTSB LAX00LA015Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-320-231 · Phoenix, AZThe airline's failure to fully review the obstruction clearances and revise the pushback procedures in an area of the ramp where new construction had impinged on the available ramp space. Also causal was the failure of the tug driver and the wing walkers to…Oct 15, 1999 · N627AW · Substantial damageNTSB LAX00FA014Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · North Las Vegas, NVThe failure of the pilot-in-command to maintain separation from terrain while operating under visual flight rules. Contributing factors were the improper issuance of a suggested heading by air traffic control personnel, inadequate flight progress monitoring…Oct 15, 1999 · N1024B · DestroyedNTSB FTW00LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Village, ARThe pilot's failure to obtain/maintain directional control during landing.Oct 15, 1999 · N66930 · Substantial damageNTSB CHI00LA011Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Grand Ledge, MIthe pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind and the tree which the airplane contacted.Oct 15, 1999 · N8353V · Substantial damageNTSB CHI00LA010Accident · No injuriesLimited investigationFinal reportCessna 172G · Cambridge, MNthe fractured main landing gear due to the improper maintenance by an unknown person(s) and the inadequate annual inspection by an unqualified person.Oct 15, 1999 · N4621L · Substantial damageNTSB NYC00WA014Accident · No injuriesForeign investigationCessna 208B · Lake Erie, CanadaOct 14, 1999 · N1117G · Substantial damageNTSB LAX00LA013Accident · Serious injuriesLimited investigationFinal reportBell 206B · Los Angeles, CA**This report was modified on 2/23/2016. Please refer to the public docket for this accident for additional information.** The pilot-in-command's excessive rate of descent and improper use of the collective control, which resulted in a low rotor rpm condition.Oct 14, 1999 · N16889 · Substantial damageNTSB LAX00LA009Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waialua, HIThe pilot's delay in recognizing the onset of a wind direction change resulting in the downward flow of wind on the leeward side of the mountain (strong sink rate).Oct 14, 1999 · N17914 · Substantial damageNTSB FTW00LA012Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Olton, TXThe inflight separation of the propeller blade due to damage from a wire strike. A factor was the lack of suitable terrain for the forced landing.Oct 14, 1999 · N23930 · Substantial damageNTSB DEN00LA004Accident · No injuriesLimited investigationFinal reportCessna 180D · Denver, COThe excessive taxi speed used by the pilot exiting the runway via a high-speed taxiway resulting in a loss of control. A factor was the crosswind.Oct 14, 1999 · N6425X · Substantial damageNTSB CHI00IA009Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-51 · Chicago, ILThe landing gear's wheel separation due to the improper installation of the wheel by company maintenance personnel using incomplete maintenance steps, and the maintenance steps not listed in the manufacturer's manual. Factors were the airport perimeter wall…Oct 14, 1999 · N766NC · No damageNTSB FTW00RA156Accident · 2 fatalForeign investigationBell 206L-1 · Quetzaltenango, GuatemalaOct 13, 1999 · TGAMANTSB CHI00LA008Accident · No injuriesLimited investigationFinal reportCessna 150F · East Troy, WIthe pilot not maintaining directional control and not obtaining a proper climb rate. Factors were the gusts, and the ground loop that was encountered. A finding was the pilot atempted a go-around.Oct 13, 1999 · N7941F · Substantial damageNTSB MIA00WA014Accident · 4 fatalForeign investigationCessna 207 · Puerto Ayacucho, VenezuelaOct 12, 1999 · YV745 · Substantial damageNTSB MIA00LA004Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Opa Locka, FLThe improper flare by the co-pilot, and the failure of the captain to take remedial action by applying power to arrest the observed high rate of descent resulting in a hard landing. A finding in the accident was the inadequate maintenance adjustment of the…Oct 12, 1999 · N438MA · Substantial damageNTSB LAX00LA007Accident · No injuriesLimited investigationFinal reportPitts S2B · Salinas, CAThe pilot's inadequate compensation for the effects of torque and P-factor during a go-around from a bounced landing, which led to a loss of control and the inadvertent dragging of a wing.Oct 11, 1999 · N50AL · Substantial damageNTSB FTW00LA030Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Lamesa, TXThe separation of the rudder control cable at the aft fairlead, as a result of wear.Oct 11, 1999 · N6044A · Substantial damageNTSB FTW00LA010Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Granite, OKCorrosion failure of the fuselage support tubing below the right wing forward attach fitting due to inadequate maintenance.Oct 11, 1999 · N4473A · Substantial damageNTSB DEN00FA005Accident · 1 fatalField investigationFinal reportWatkins Christen Eagle · Brigham City, UTThe pilot's inability to maintain aircraft control due to an unknown physical impairment.Oct 11, 1999 · N24JT · DestroyedNTSB ANC00LA004Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Soldotna, AKAn in-flight collision with a bird.Oct 11, 1999 · N74923 · Substantial damageNTSB NYC00LA012Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Whiting, VTThe pilot's inadequate preflight passenger briefing, which resulted in control interference.Oct 10, 1999 · N403AC · Substantial damageNTSB CHI00LA007Accident · No injuriesLimited investigationFinal reportCessna 150M · Wheeling, ILaircraft control not maintained by the pilot. A factor to the accident was the windshear.Oct 10, 1999 · N2977V · Substantial damageNTSB NYC00LA011Accident · No injuriesLimited investigationFinal reportCessna 172I · N. East Carry, METhe pilot's decision to attempt a takeoff under gusty wind and rough water conditions.Oct 9, 1999 · N35669 · Substantial damageNTSB NYC00LA010Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Fredericksburg, PAWas the inadequate visual lookout by the pilot of the Stearman.Oct 9, 1999 · N52951 · 2 aircraft · Minor damageNTSB NYC00LA009Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Burkittsville, MDThe vehicle drivers inadequate lookout.Oct 9, 1999 · N7856 · Substantial damageNTSB LAX00LA008Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Yuma, AZThe pilot's inadequate compensation for the existing crosswind conditions.Oct 9, 1999 · N871C · Substantial damageNTSB FTW00LA009Accident · Minor injuriesLimited investigationFinal reportCessna 150G · El Reno, OKThe total loss of engine power resulting from a fatigue failure of the intake rocker arm for the #4 cylinder. A factor was the soft terrain encountered during the forced landing.Oct 9, 1999 · N3603J · Substantial damageNTSB DEN00LA006Accident · No injuriesLimited investigationFinal reportKendall/Mckaughlin Rans S-10 Sakota · Hudson, COInadequate preflight planning when the pilot failed to evaluate aircraft performance and weather. Factors were high density altitude, and unsuitable terrain for a forced landing.Oct 9, 1999 · N444YB · Substantial damage