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 CHI01LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mandan, NDthe pilot failed to maintain clearance from the powerline. Additional factors were the thermal lift and the powerline.NTSB CHI01LA216Accident · No injuriesLimited investigationFinal reportStemme S10-VT · Antigo, WIThe cause of the loss of engine power and in-flight fire was undetermined.NTSB CHI01LA214Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Langdon, NDthe pilot stalled the airplane while manuevering to avoid the power lines. A factor was the power lines.NTSB CHI01LA213Accident · Serious injuriesLimited investigationFinal reportLaPorte MXL II Sport · Gaines Twp., MIThe pilot's poor planning which resulted in foreign object damage to the propeller, and the low altitude at which the loss of power occurred which resulted in the pilot not being able to properly flare the airplane. Factors associated with the accident were…NTSB CHI01LA212Accident · 1 fatalLimited investigationFinal reportReitz Mohawk 1 · Camdenton, MOThe pilot not performing an aborted takeoff and the inadvertent stall he encountered on his inadvertent initial climb. Factors were his inadvertent lift-off, the reported inadequate rudder control, his inadvertent flight with known deficiencies, and the…NTSB CHI01LA210Accident · No injuriesLimited investigationFinal reportCessna 140 · Spearfish, SDThe pilot failed to maintain directional control of the airplane during the landing. Factors associated with the accident were the pilot's inadequate recovery from a bounced landing and his lack of experience in the make and model of the accident airplane.NTSB SEA01LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tekoa, WAThe non-current pilot's failure to maintain sufficient altitude or clearance with wheat crops on short final, and the flight instructor's inadequate remedial action. Factors included wheat crops and a dirt bank on short final, the runway's lack of a visual…NTSB LAX01LA245Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Blythe, CAThe selection by the pilot of an unsuitable precautionary landing site on soft, uneven terrain, which resulted in a rollover.NTSB CHI01FA206Accident · 6 fatalField investigationFinal reportBeech E-55 · Carterville, MOThe pilot's failure to maintain aircraft control and the pilot's improper in-flight planning and decisions. Factors relating to the accident were the pilot's lack of experience in the airplane, the inadvertent spiral, and the residence.NTSB ATL01IA083Incident · No injuriesIncident investigationFinal reportBoeing B-727-100 · Memphis, TNThe failure of the #3 engine starter turbine.NTSB NYC01LA170Accident · No injuriesLimited investigationFinal reportTaylorcraft F21B · Simsbury, CT**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional details.** a loose tail wheel assembly and the failure of maintenance personnel to adequately follow annual inspection procedures. A factor in the accident…NTSB MIA01LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Boca Raton, FLA loss of engine power, and the pilot unable to feather the propeller for undetermined reasons, which resulted in a forced landing on a highway, subsequent impact with a pole and vehicles.NTSB LAX01LA307Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · San Francisco, CAthe captain's excessive use of the flight controls to level off from a descent, which resulted in a passenger injury.NTSB LAX01LA246Accident · No injuriesLimited investigationFinal reportMooney M20J · Las Vegas, NVThe pilot's inadaquate visual lookout and failure to maintain proper clearance from an object. A factor was the pilot's distraction by a conversation with ground control.NTSB LAX01LA243Accident · No injuriesLimited investigationFinal reportBell 206B · San Francisco, CAThe failure of the accessory gearbox 2 1/2 bearing in fatigue resulting in the complete loss of engine power and a subsequent forced landing. The pilot's failure to maintain directional control during the autorotational flare maneuver is also causal. The…NTSB FTW01LA164Accident · Minor injuriesLimited investigationFinal reportYoung RV-6 · Spring, TXthe loss of engine power for undetermined reasons during the landing approach. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA207Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Ionia, MIThe pilot not maintaining clearance from the tall grass during his recovery from the bounced landing. A factor was the tall grass.NTSB CHI01IA211Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Whiteman AFB, MOThe separation of a fan blade due to fatigue failure which led to case separation and loss of engine power in the left engine.NTSB ATL01FA082Accident · 2 fatalField investigationFinal reportLuscombe 8A · Resaca, GAThe certificated flight instructor's failure to maintain control of the airplane during a turning maneuver, which resulted in an inadvertent stall and subsequent collision with terrain. A factor was the loading of the airplane over maximum gross weight.NTSB MIA01LA181Accident · 1 fatalLimited investigationFinal reportFloback Lancair 4 · Kissimmee, FLthe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain.NTSB LAX01LA242Accident · No injuriesLimited investigationFinal reportCessna 310I · Amargosa Valley, NVThe pilot's attempt to depart on a taxiway unsuitable for takeoff under existing conditions. An additional factor was a berm at the end of the taxiway.NTSB DCA01WA049Incident · No injuriesForeign investigationMcDonnell Douglas MD-83 · Rome, ItalyNTSB CHI01LA205Accident · No injuriesLimited investigationFinal reportCessna 172S · Lake in the Hil, ILThe student pilot misjudging the flare during that landing. Factors were the wrong runway selected by the student pilot, the tailwinds encountered during that landing and the flight instructor's inadequate supervision during that landing.NTSB CHI01FA204Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Lafayette, INThe fuel exhaustion due to the pilot's alcohol impaired decision making. Additional factors were the trees and night.NTSB WAS01RA012Accident · Serious injuriesForeign investigationCessna 208B · La Paz, BoliviaNTSB SEA01LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R · Cut Bank, MTThe pilot's failure to maintain a speed above stall velocity (Vs) during the after-takeoff climb. Factors include a high density altitude, and a dust devil/whirlwind located along the route of departure.NTSB SEA01FA127Accident · 1 fatalField investigationFinal reportRockwell S-2R-1200 · Cottonwood, IDFailure to maintain adequate clearance from terrain while dropping fire retardant. Factors include low visibility with smoke.NTSB NYC01LA168Accident · No injuriesLimited investigationFinal reportBell 206B · Secaucus, NJUnder torque of a Thomas coupling self-locking nut for undetermined reasons, which resulted in the loss of the corresponding retaining bolt, and subsequent separation of tail rotor drive shaft segments. A factor was the unsuitable terrain beneath the pilot…NTSB NYC01FA169Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Medford, NJThe pilot's improper use of the flight controls while turning to base, which resulted in a stall/spin and subsequent impact with the ground.NTSB MIA01WA183Accident · 1 fatalForeign investigationMooney M20M · Manhay, BelgiumNTSB FTW01LA176Accident · No injuriesLimited investigationFinal reportSikorsky SK-76A · New Iberia, LAthe loss of control while maneuvering for undetermined reasons.NTSB FTW01LA161Accident · No injuriesLimited investigationFinal reportCessna 172 · Kingston, OKthe pilot's failure to maintain directional control during the takeoff roll, which required his evasive maneuver and resulted in a stall.NTSB CHI01LA208Accident · No injuriesLimited investigationFinal reportCessna 210 · Saint Charles, MOthe inadequate flare by the pilot.NTSB CHI01LA202Accident · No injuriesLimited investigationFinal reportCessna 172N · West Chicago, ILThe instructor pilot's inadequate recovery from the bounced landing and inadequate supervision of the dual students alignment with the runway. A factor was the student pilot not maintaining proper alignment with the runway during landing.NTSB ATL01LA075Accident · No injuriesLimited investigationFinal reportBell 47 · Indianola, MSThe pilot's improper use of flight controls during an autorotation that resulted inn the collapse of the skids and cross tube assembly. A factor was the loss of engine power due to the failure of # 1 connecting rod and the overload failure of the skids and…NTSB NYC01LA167Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Clay, NYFailure of the left aft cluster fitting due to a fatigue crack. Factors in the accident were the mechanic's failure to identify the crack at the last annual inspection, and the pilot's failure to identify the crack during the last daily inspectionNTSB FTW01LA169Accident · Serious injuriesLimited investigationFinal reportClark CGS Hawk · Bullard, TXthe pilot's failure to maintain clearance with power lines during low level maneuvers.NTSB FTW01LA162Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Caldwell, TXthe solo student pilot's intentional engine shutdown, while practicing emergency landing prodecures. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL01TA081Accident · No injuriesFinal reportHughes TH-55 · Midway, GAThe loss of engine power for undetermined reasons. A factoe was the lack of suitable terrain upon which an emergency landing could be made, which resulted in a rollover upon touchdown in a marshy area.NTSB ATL01LA104Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Pahokee, FLThe pilot's failure to follow the checklist while making an approach for landing resulting in a wheels up landing. Contributing to the accident was the certified flight instructor inadequate supervision of the rated pilot receiving instruction.NTSB ATL01LA078Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-3 · Titusville, FLThe pilot's failure to maintain directional control during a bounced landing, resulting in a ground loop and subesequent collision with the runway.NTSB WAS01RA011Accident · 2 fatalForeign investigationRobinson R-44 · La Fortuna, ParaguayNTSB SEA01WA125Accident · Minor injuriesForeign investigationPilatus PC-12/45 · Sea of Okhotsk (Pacific Ocean)NTSB NYC01LA166Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Boston, MAThe pilot's improper decision to waive the wake turbulence hold time, and his subsequent loss of control when wake vortex turbulence was encountered.NTSB DCA01WA050Incident · No injuriesForeign investigationBoeing 777 · Frankfurt, GermanyNTSB CHI01LA200Accident · No injuriesLimited investigationFinal reportCessna 175 · Tomahawk, WIThe inadequate preflight preparation that did not include calculating the density altitude and the pilot not maintaining clearance from the second row of trees on initial climb. Factors include those trees and the high density altitude present at the time of…NTSB SEA01LA129Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fragaria, WAThe pilot's failure to maintain adequate directional control. Contributing factors were the embankment and the deer.NTSB SEA01LA128Accident · No injuriesLimited investigationFinal reportTibert Baby Lakes · Stevensville, MTThe pilot's failure to maintain directional control of the tailwheel-equipped aircraft during the landing roll. Factors include the pilot's low total time in this make and model aircraft and his lack of recent experience in this make and model aircraft.NTSB LAX01LA239Accident · 2 fatalLimited investigationFinal reportJohansen/Thiessen RV-6A · Jackpot, NVthe private pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall and impact with terrain.NTSB LAX01LA238Accident · No injuriesLimited investigationFinal reportSparks KR-2 · San Diego, CAFailure of the pilot to maintain directional control during landing.