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 GAA19CA375Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe student pilot's improper landing flare and failure to maintain the runway heading, which resulted in the loss of airplane control, and the flight instructor's delayed remedial action during a go-around with a crosswind, which resulted in a bounced landing…NTSB ERA19LA217Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 77 · Leesburg, FLA partial loss of engine power due to carburetor icing, which resulted from the flight instructor's decision not to use carburetor heat.NTSB CEN19LA187Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Danbury, TXA failed electrical relay, which provided an improper indication of a governor and clutch problem, which resulted in the pilot conducting a precautionary landing during which he failed to maintain sufficient main rotor speed.NTSB CEN19LA186Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Omaha, NEThe loss of engine power due to fuel starvation.NTSB CEN19FA189Accident · 1 fatalField investigationFinal reportBeechcraft 58 · Hiawatha, KSThe pilot's loss of control for undetermined reasons.NTSB CEN19FA185Accident · 2 fatalClass 2 · FieldFinal reportAgusta A109 · Brainerd, MNThe pilot's spatial disorientation during an instrument approach in dark night instrument meteorological conditions, which resulted in a loss of control and subsequent impact with terrain.NTSB WPR19LA179Accident · Minor injuriesClass 3 · LimitedFinal reportStinson 108 · Caldwell, IDA total loss of engine power during approach due to a failed piston. The reason for the piston failure could not be determined based on the available information.NTSB WPR19FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172 · Pescadero, CAImpact with the ocean for reasons that could not be determined because the airplane was not located.NTSB GAA19WA386Accident · 2 fatalForeign investigationCessna 182 · Chimaltenango, GuatemalaNTSB GAA19CA395Accident · No injuriesData collectionFinal reportMaule M5 · Gillette, WYThe pilot's selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB GAA19CA385Accident · No injuriesData collectionFinal reportPiper PA 12 · Skwentna, AKThe pilot's use of excessive brakes during an aborted takeoff, which resulted in a nose-over.NTSB GAA19CA377Accident · No injuriesData collectionFinal reportCessna 177 · Pleasanton, KSThe pilot's loss of yaw control during takeoff with a right quartering headwind in gusting wind conditions, which resulted in a collision with trees.NTSB GAA19CA374Accident · Minor injuriesData collectionFinal reportVans RV 6 · Monument Valley, UTThe pilot's exceedance of the airplane's critical angle of attack during the aborted landing, which resulted in an aerodynamic stall.NTSB ERA19LA219Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV 4 · Williamson, GAThe pilot's inadvertent misplacement of the fuel selector, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA19FA201Accident · 2 fatalClass 2 · FieldFinal reportBeech E55 · Hope Mills, NCThe pilot's failure to disengage an uncommanded nose-down pitch input. Contributing to the accident was improper maintenance of the pitch trim servo, which would have precluded a physical override of the pitch servo.NTSB CEN19LA188Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 560 · Janesville, WIThe passenger’s decision to unbuckle her restraints during an in-flight turbulence event, resulting in serious injury.NTSB ANC19LA028Accident · No injuriesClass 3 · LimitedFinal reportDe Havilland DHC-2 · Ketchikan, AKA loss of directional control while landing, which resulted in a water loop.NTSB GAA19CA435Accident · No injuriesData collectionFinal reportPiper PA34 · State College, PAThe pilot's improper landing flare in gusting wind conditions, which resulted in a bounced landing and landing gear collapse.NTSB GAA19CA427Accident · No injuriesData collectionFinal reportBeech 35 · Caldwell, NJThe pilot's distraction while looking for traffic, which led to his failure to extend the landing gear before landing, and his exceedance of the airplane's critical angle of attack during a subsequent go-around, which resulted in an aerodynamic stall.NTSB GAA19CA403Accident · Minor injuriesData collectionFinal reportMd Helicopter 369 · Summersville, SCThe copilot’s disabling of the flight controls of an operating helicopter without telling the pilot on the controls, which resulted in a subsequent loss of control and collision with terrain.NTSB ERA19FA200Accident · 2 fatalClass 2 · FieldFinal reportRans S6 · Fletcher, NCThe exceedance of the airplane's critical angle of attack during climb, which resulted in an aerodynamic stall and spin at low altitude. Contributing was the lack of experience both pilots possessed in the accident airplane.NTSB CEN19TA196Accident · No injuriesFinal reportAeronca 65 C · Gilliam, LAThe pilot's failure to see and avoid a dark-colored utility pole while taxiing for takeoff.NTSB GAA19CA383Accident · No injuriesData collectionFinal reportPiper PA28 · Milton, FLThe flight instructor's intentional overapplication of rudder to avoid a ditch during landing with a tailwind, which resulted in a runway excursion and landing gear collapse.NTSB ERA19LA206Accident · No injuriesClass 3 · LimitedFinal reportBell OH58C · Gainesville, FLThe flight instructor's failure to maintain control of the helicopter during a simulated forced landing autorotation, which resulted in pylon whirl that substantially damaged the helicopter.NTSB CEN19WA255Accident · No injuriesForeign investigationCessna Cessna 441 · Glasgow, IrelandOn June 25, 2019, about 0800 coordinated universal time, a Cessna 441 airplane, EI-DMG, experienced a propeller strike during landing at the Glasgow Prestwick Airport.The accident investigation is under the jurisdiction and control of the Air Accidents…NTSB GAA19CA371Accident · No injuriesData collectionFinal reportCessna 182 · Presidio, TXThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with vegetation.NTSB CEN19LA183Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · Greeley, COThe pilot’s improper landing flare, which resulted in failure of the right main landing gear and a subsequent loss of control.NTSB GAA19CA413Accident · No injuriesData collectionFinal reportCessna 152 · Clewiston, FLThe student pilot's maneuver to the left to avoid striking birds during takeoff and his subsequent loss of directional control after aborting the takeoff and landing on soft, muddy grass adjacent to the runway during, which resulted in a nose-over.NTSB CEN19LA184Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Vine Grove, KYThe pilot’s failure to maintain a proper visual lookout during the approach, which resulted in inadequate clearance from a tree.NTSB WPR19WA277Accident · No injuriesForeign investigationRobinson R22 · Kutchera Station, AustraliaOn June 22, 2019, at 0900 local time, a Robinson R22 helicopter, VH-HHQ, collided with terrain near Kutchera Station, Australia. The pilot was fatally injured and the helicopter was substantially damaged. The flight was conducted under the pertinent civil…NTSB WPR19MA177Accident · 11 fatalClass 2 · MajorFinal reportBeech 65-A90 · Mokuleia, HIThe pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…NTSB WPR19FA178Accident · 1 fatalClass 2 · FieldFinal reportMaule M7-235B · Sunriver, ORA partial loss of engine power due to the separation of baffling in both mufflers. Contributing to the accident was the pilot's failure to retract the landing gear on the float-equipped airplane before performing a forced landing to the river.NTSB GAA19CA415Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB GAA19CA368Accident · No injuriesData collectionFinal reportCessna 172 · Tulsa, OKThe pilot's failure to maintain directional control while landing in gusting crosswind conditions, which resulted in a runway excursion and impact with a taxiway sign.NTSB CEN19WA288Accident · 2 fatalForeign investigationZenair CH601 · Pont-A-Celles, BelgiumThe government of Belgium has notified the National Transportation Safety Board (NTSB) of an accident involving a Zenair CH 601XL airplane that occurred on June 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB CEN19WA200Accident · 1 fatalForeign investigationPiper PA28 · Mandal, NorwayOn June 22, 2019, about 1255 local time, a Piper PA28-161, registration NL-MTJ, impacted the sea about 11 miles south of Mandal, Norway, following a loss of engine power. One person was fatally injured, and two passengers received minor injuries. The Accident…NTSB CEN19TA180Accident · Serious injuriesClass 3Final reportElmwood Christavia · Lancaster, SCThe pilot's distraction, which resulted in his failure to maintain adequate altitude and airspeed and a subsequent impact with terrain.NTSB CEN19LA213Accident · No injuriesClass 3 · LimitedFinal reportErcoupe 415 · Smithfield, RIThe pilot’s failure to use carburetor heat on approach in weather conditions conducive to carburetor icing, which resulted in a forced landing to a pond.NTSB CEN19LA204Accident · No injuriesClass 3 · LimitedFinal reportWaco YMF-5C · Bar Harbor, MEA total loss of engine power due to a cylinder failure for undetermined reasons.NTSB CEN19LA181Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver Sport · Barnesville, OHThe pilot's loss of control for undetermined reasons.NTSB WPR19LA176Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fullerton, CAPartial loss of engine power during takeoff due to an age-degraded carburetor heat valve seal, which detached and partially blocked the carburetor air inlet. Contributing to the accident was an inadequate maintenance inspection.NTSB GAA19CA379Accident · No injuriesData collectionFinal reportCirrus SR22 · Grotten, CTThe pilot's improper landing flare and failure to maintain pitch control, which resulted in a porpoised landing.NTSB GAA19CA369Accident · No injuriesData collectionFinal reportPiper L21 · Imnaha, ORThe pilot's failure to maintain directional control while taking off from a soft, rough field, which resulted in a ground-loop.NTSB GAA19CA366Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Yerington, NVThe pilot's failure to properly secure the airplane before hand propping it, which resulted in the unmanned airplane moving and colliding with a fence.NTSB GAA19CA365Accident · No injuriesData collectionFinal reportCessna 182 · Burley, IDThe pilot's improper landing flare during landing in a gusting, right quartering tailwind, which resulted in the airplane wheel barrowing and a subsequent runway overrun, impact with terrain, and noseover.NTSB ERA19LA202Accident · No injuriesClass 3 · LimitedFinal reportAeronca S7EC · Jasper, ALA total loss of engine power due to fuel contamination.NTSB DCA19CA170Accident · No injuriesData collectionFinal reportBoeing CV2 · Beeville, TXA higher than expected and accounted for crosswind which initiated a lateral deviation, and resulted in the aircraft reaching the limits of the geo-fence area triggering a contingency forced landing.NTSB CEN19TA178Accident · No injuriesClass 3Final reportRobinson R44 · La Ward, TXThe pilot’s failure to maintain helicopter control during a course reversal, which resulted in impact with terrain.NTSB CEN19LA179Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Cottrellville Township, MIThe partial loss of engine power due to carburetor icing and the pilot’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing. The reason for the pilot’s inability to advance the throttle for the go-around could not be…NTSB ANC19FA026Accident · 3 fatalField investigationFinal reportHelio H 250 · Seward, AKThe pilot's failure to maintain clearance from trees during takeoff, which resulted in an in-flight collision, a loss of control, and impact with terrain.