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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB NYC00WA015Accident · 1 fatalForeign investigationPiper PA-46-350P · Cranbrook, CanadaNTSB 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…NTSB 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.NTSB FTW00WA020Accident · 3 fatalForeign investigationCessna 182P · Coban, GuatemalaNTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB DCA00RA002Accident · Minor injuriesForeign investigationMcDonnell Douglas MD-11F · Subic Bay, PhilippinesNTSB 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.NTSB 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.NTSB MIA00LA012Accident · No injuriesLimited investigationFinal reportBeech D35 · Indiantown, FLThe reported unauthorized use of the airplane by an unknown person.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB ANC00LA006Accident · No injuriesLimited investigationFinal reportPiper PA-31-T3 · Gambell, AKAn in-flight collision with a bird.NTSB 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…NTSB 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…NTSB 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…NTSB FTW00LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Village, ARThe pilot's failure to obtain/maintain directional control during landing.NTSB 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.NTSB 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.NTSB NYC00WA014Accident · No injuriesForeign investigationCessna 208B · Lake Erie, CanadaNTSB 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.NTSB 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).NTSB 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.NTSB 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.NTSB 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…NTSB FTW00RA156Accident · 2 fatalForeign investigationBell 206L-1 · Quetzaltenango, GuatemalaNTSB 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.NTSB MIA00WA014Accident · 4 fatalForeign investigationCessna 207 · Puerto Ayacucho, VenezuelaNTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB DEN00FA005Accident · 1 fatalField investigationFinal reportWatkins Christen Eagle · Brigham City, UTThe pilot's inability to maintain aircraft control due to an unknown physical impairment.NTSB ANC00LA004Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Soldotna, AKAn in-flight collision with a bird.NTSB NYC00LA012Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Whiting, VTThe pilot's inadequate preflight passenger briefing, which resulted in control interference.NTSB CHI00LA007Accident · No injuriesLimited investigationFinal reportCessna 150M · Wheeling, ILaircraft control not maintained by the pilot. A factor to the accident was the windshear.NTSB NYC00LA011Accident · No injuriesLimited investigationFinal reportCessna 172I · N. East Carry, METhe pilot's decision to attempt a takeoff under gusty wind and rough water conditions.NTSB NYC00LA010Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Fredericksburg, PAWas the inadequate visual lookout by the pilot of the Stearman.NTSB NYC00LA009Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Burkittsville, MDThe vehicle drivers inadequate lookout.NTSB LAX00LA008Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Yuma, AZThe pilot's inadequate compensation for the existing crosswind conditions.NTSB 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.NTSB 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.