NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ANC19LA027Accident · No injuriesClass 3 · LimitedFinal reportHelio H391 · Hope, AKThe pilot’s failure to maintain directional control during a precautionary landing, which resulted in a ground loop. Contributing to the accident was a partial loss of engine power for reasons that could not be determined.NTSB ANC19LA024Accident · No injuriesClass 3 · LimitedFinal reportAeronca 7DC · Nome Creek, AKThe failure of the airplane's structural tubing due to corrosion, which resulted in a tailwheel separation and a subsequent loss of control. Also causal was the mechanic's failure to perform a detailed inspection of the aft fuselage during the most recent…NTSB WPR19LA167Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20V · Phoenix, AZThe partial loss of engine power during cruise flight for reasons that could not be determined with the available evidence.NTSB GAA19CA346Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, TXThe passing pilot’s failure to maintain clearance from the airplane that he was attempting to pass during taxi operations. Contributing to the accident was the passing pilot's distraction due to looking at his on-board navigation device while attempting to…NTSB GAA19CA343Accident · No injuriesData collectionFinal reportMaule MX7 · Soldatna, AKThe pilot’s attempt to land on water in an airplane that was not equipped with floats.NTSB DCA19WA163Accident · No injuriesForeign investigationCasa C212 · Kuinga, KenyaThe Ministry of Transport of the Republic of Kenya has notified the NTSB of an accident involving a CASA 212, which occurred on June 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under the provisions of ICAO…NTSB CEN19LA163Accident · Serious injuriesClass 3 · LimitedFinal reportGriff Challenger · Switz City, INA total loss of engine power due to failure of a connecting rod bearing. Contributing to the engine failure was the lack of an engine overhaul within the prescribed interval.NTSB WPR19LA166Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Romona, CAA total loss of engine power due to oil starvation as a result of the failure of an oil filter adapter fiber gasket.NTSB WPR19FA163Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Antioch, CAA loss of control while conducting low-altitude, high-speed maneuvers.NTSB GAA19CA345Accident · Serious injuriesData collectionFinal reportS M & T UH · Northway, AKThe pilot's failure to maintain a proper descent rate during landing, which resulted in impact with terrain.NTSB GAA19CA338Accident · No injuriesData collectionFinal reportPzl-Swidnik PW-5 · Independence, WIThe separation of the canopy from the glider during an off-airport landing for reasons that could not be determined.NTSB GAA19CA336Accident · Minor injuriesData collectionFinal reportCessna 180 · Ontario, ORThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB ERA19FA191Accident · 1 fatalClass 3 · FieldFinal reportAgusta A109 · New York, NYThe non-instrument-rated pilot’s decision to initiate the flight into marginal visual flight rules and instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.NTSB CEN19LA168Accident · No injuriesClass 3 · LimitedFinal reportRockwell 690 · Jacksonville, FLThe overstress fracture of the roll pin in the nose landing gear (NLG) spacer assembly which caused interference between the nose wheel actuator rod and the left forward gear door actuating rods preventing the NLG to fully extend into the full down and locked…NTSB CEN19FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 425 · Butler, MOThe pilot’s loss of airplane control during a descent to a diversion airport with only the left engine operating. Contributing to the accident was a malfunction of the right engine throttle, the cause of which could not be determined.NTSB GAA19WA597Accident · No injuriesClass 4 · ForeignPiper PA28 · Buenos Aires, ArgentinaNTSB GAA19WA391Accident · 3 fatalForeign investigationPiper PA23 · Mulakot, IcelandNTSB GAA19CA476Accident · No injuriesData collectionFinal reportRobinson R44 · Lebanon, MOThe pilot's loss of yaw control and failure to maintain a proper descent rate and his subsequent improper use of the collective instead of the antitorque pedals to correct the yaw, which resulted in a hard landing.NTSB GAA19CA354Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · La Ward, TXThe pilot's failure to maintain clearance from a wire during an aerial application flight in sun glare conditions.NTSB GAA19CA335Accident · No injuriesData collectionFinal reportCessna 421 · Moriarty, NMThe pilot's improper landing flare in gusting wind conditions, which resulted in a hard landing.NTSB GAA19CA333Accident · No injuriesData collectionFinal reportPiper PA22 · Riverside, CAThe pilot's failure to the maintain the runway heading during landing with a crosswind, which resulted in impact with runway lighting and a subsequent ground loop during the landing roll.NTSB GAA19CA325Accident · No injuriesData collectionFinal reportAviat A1 · Pingree, IDThe pilot's improper rudder application during landing on a dirt airstrip, which resulted in a loss of directional control, runway excursion, and subsequent nose-overNTSB GAA19CA324Accident · No injuriesData collectionFinal reportDavid Shotwell Murphy · South Lake Tahoe, CAThe pilot's failure to properly tighten his seat belt, which allowed him to slide forward in his seat and resulted in his inadvertent application of excessive brake application during the landing roll and a subsequent noseover.NTSB GAA19CA323Accident · No injuriesData collectionFinal reportCessna 172 · Yellow Pine, IDThe pilot's improper approach, which resulted in the airplane touching down with insufficient runway remaining to stop on the runway, a runway overrun, and subsequent collision with bushes and terrain.NTSB GAA19CA322Accident · No injuriesData collectionFinal reportCirrus SR22 · Trenton, NJThe pilot's failure to maintain directional control during landing with gusting crosswind conditions, which resulted in a runway excursion and subsequent substantial damage.NTSB DCA19CA169Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · Denver, COthe early initiation of the landing flare that resulted in a high pitch attitude and tailstrike.NTSB WPR19TA162Accident · Minor injuriesClass 3Final reportBeech 35 · Medford, ORThe pilot’s mismanagement of fuel onboard, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR19FA161Accident · 1 fatalClass 2 · FieldFinal reportLockwood Aircam · Hemet, CAThe pilot/builder's improper installation of the left wing during the build process, which resulted in the wing failing during takeoff.NTSB GAA19CA332Accident · Minor injuriesData collectionFinal reportBeech 35 · Rose Hill, KSThe pilot's improper trim configuration during the takeoff roll, which resulted in the airplane becoming prematurely airborne, and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA19CA327Accident · No injuriesData collectionFinal reportCessna 185 · Gulkana, AKThe pilot's loss of airplane control just before touchdown in gusting wind conditions, which resulted in ground loop after touchdown.NTSB GAA19CA326Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe student pilot's excessive rudder application during takeoff and the flight instructor's delayed remedial action, which resulted in a loss of directional control, a runway excursion, and subsequent substantial damage.NTSB GAA19CA321Accident · Minor injuriesData collectionFinal reportCessna 180 · Moses Lake, WAThe pilot's improper landing flare and his delayed decision to go-around, which resulted in impact with rocks on a shoreline.NTSB ERA19FA189Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Southold, NYA total loss of engine power due to a main bearing shift and the pilot’s subsequent failure to maintain a proper glide path to the selected forced landing site. Contributing to the accident was the pilot’s decision to operate the airplane with known…NTSB CEN19LA162Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Last Chance, COThe pilot's failure to maintain adequate main rotor rpm while descending with a tailwind during an aerial application maneuver, which resulted in an uncontrolled descent into terrain.NTSB WPR19LA160Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Davis City, CAA total loss of engine power due to water contamination in the fuel, which resulted in a forced landing and collision with terrain. Contributing to the accident was the pilot's improper decision to proceed with the flight after discovering the contaminated…NTSB GAA19WA541Accident · No injuriesForeign investigationCessna C 680 · Salta, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a CESSNA C 680 airplane that occurred on July 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…NTSB GAA19CA355Accident · No injuriesData collectionFinal reportCessna 180 · Santa Fe, NMThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a wing strike.NTSB GAA19CA350Accident · No injuriesData collectionFinal reportPiper PA28 · Nowdoinham, METhe flight instructor's delayed decision to abort the takeoff from a wet, grass runway with insufficient runway remaining, which resulted in a runway overrun and the airplane going down an embankment.NTSB GAA19CA331Accident · Minor injuriesData collectionFinal reportCessna 150 · Lee's Summit, MOThe student pilot’s exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA19CA330Accident · No injuriesData collectionFinal reportDiamond DA20 · Terre Haute, INThe student pilot's failure to maintain the runway heading and to relinquish the flight controls to the flight instructor when told to do so while landing in gusting, crosswind conditions, which resulted in a runway excursion and impact with runway lighting.NTSB GAA19CA329Accident · No injuriesData collectionFinal reportErcoupe 415 · Lafayette, INThe flight instructor's failure to maintain pitch control and his improper landing flare, which resulted in a hard landing.NTSB GAA19CA328Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Monument, KSThe pilot's failure to maintain altitude due to distraction by ground equipment in the airplane’s path, which resulted in his failure to maintain clearance from crops during an agricultural application flight and resulted in a loss of airplane control.NTSB GAA19CA320Accident · No injuriesData collectionFinal reportCessna A185 · Ashland, METhe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a tree.NTSB ERA19FA188Accident · 4 fatalClass 3 · FieldFinal reportPiper PA46 · Castalia, NCThe pilot’s failure to navigate around hazardous weather, resulting in the penetration of a thunderstorm, a loss of airplane control, and an inflight breakup. The air traffic controller’s failure to provide the pilot with adequate and timely weather…NTSB GAA19WA414Incident · No injuriesForeign investigationCessna 207 · Birtingarholt, IcelandNTSB GAA19CA344Accident · No injuriesData collectionFinal reportBell UH 1H · Bethel, AKThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power, and his improper landing flare during a forced autorotation, which resulted in a hard landing. Contributing to the accident were the inoperative fuel…NTSB GAA19CA319Accident · No injuriesData collectionFinal reportPiper PA24 · Weiner, ARThe pilot's failure to maintain directional control during the landing roll on a wet runway, which resulted in a runway overrun and collision with a pole.NTSB ERA19WA293Accident · 3 fatalClass 3 · ForeignBell 505 · Kazbegi, GeorgiaNTSB ERA19TA195Accident · No injuriesClass 3Final reportPiper PA28 · Westminster, MDThe pilot's failure to maintain directional control during recovery from a bounced landing, which resulted in a runway excursion.NTSB ERA19LA187Accident · Minor injuriesClass 3 · LimitedFinal reportAvid Avid Magnum · Frederick, MDThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion. Contributing to the accident was the pilot’s and instructor’s lack of experience in the make and model of the airplane.