NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 CEN13LA381Accident · No injuriesLimited investigationFinal reportBeech C23 · Hot Springs, ARThe pilots’ failure to monitor and manage fuel consumption during cruise flight, which resulted in fuel exhaustion and a subsequent forced landing.NTSB CEN13CA386Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Climax Springs, MOThe pilot’s inadequate planning and poor decision to attempt to take off on a runway from which the airplane could not obtain flight.NTSB WPR13LA318Accident · Serious injuriesLimited investigationFinal reportChicco Quicksilver Sport II · Newbury Park, CAThe partial loss of engine power while maneuvering due to the blockage of the exhaust system by broken internal engine baffles that had shifted during the flight, which resulted in a forced landing and subsequent impact with terrain.NTSB WPR13FA300Accident · 2 fatalField investigationFinal reportAllstar PZL Glider SZD-54-2 Perkoz · Jacumba, CAThe premature release of the towline from the glider and the glider’s subsequent right banking turn at low altitude for reasons that could not be determined because postaccident airframe examination did not reveal any evidence of a mechanical malfunction or…NTSB WPR13FA298Accident · 2 fatalField investigationFinal reportAyers Less Drag Special · Oxnard, CAA loss of engine power after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and the pilot’s failure to maintain adequate airspeed, which resulted in an…NTSB ERA13LA312Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Jackson, TNA failure of the right main landing gear wheel rim during the landing roll, resulting in a loss of control and a subsequent collapse of the right main landing gear.NTSB ERA13LA308Accident · Serious injuriesLimited investigationFinal reportHiller UH-12A · Florence, ALThe student pilot’s failure to maintain control of the helicopter while landing, which resulted in a tail rotor ground strike and collision with terrain.NTSB CEN13WA393Accident · 3 fatalForeign investigationCessna 185 · Vehmersalmi, FinlandOn June 29, 2013, at 1530 local time, a Cessna 185D seaplane, serial number 185-0863, Finnish registration OH-CEG, owned by Werner Air Oy, was destroyed after impacting the surface of Lake Sulasvesi, Vehmersalmi, Finland. The pilot and two passengers were…NTSB CEN13CA385Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Waynesville, OHThe pilot did not attain a proper touchdown point during the landing. Contributing to the accident was the simulated altimeter and spoiler failure and the flight instructor's lack of remedial action.NTSB ANC13LA059Accident · No injuriesLimited investigationFinal reportCessna 175 · Skwentna, AKThe partial loss of engine power for reasons that could not be determined because the postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation. .NTSB WPR13LA303Accident · Serious injuriesLimited investigationFinal reportBell 206L-3 · Missoula, MTThe pilot's failure to prevent the helicopter from settling with power and to maintain proper position relative to an external load, which resulted in a loss of control and subsequent hard landing.NTSB WPR13LA299Accident · No injuriesLimited investigationFinal reportCessna 172 - N · Trout Lake, WAThe pilot's failure to maintain clearance from trees during takeoff from a soft field and to abort the landing when the airplane reached the runway’s midpoint at a low airspeed.NTSB WPR13LA295Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Fielding, UTThe pilot's failure to maintain rotor rpm while traversing a canyon in high-density altitude and gusting wind conditions.NTSB WPR13FA296Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Yellow Pine, IDThe pilot's failure to see and avoid the airplane ahead of his position in the airport traffic pattern, which resulted in a midair collision while both airplanes were on approach to land. Contributing to the accident was both pilots’ failure to adequately…NTSB WPR13CA297Accident · Minor injuriesData collectionFinal reportCharles Peet Zenith CH 701 · Jackson, WYThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall during takeoff/initial climb.NTSB ERA13CA307Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Okeechobee, FLThe student pilot’s failure to maintain directional control during a go-around.NTSB CEN13LA396Accident · No injuriesLimited investigationFinal reportBell 47D1 · Lake Ozark, MOThe improper rebuild and maintenance of the helicopter and inadequate subsequent inspections, which resulted in undetected fuel contamination and a subsequent total loss of engine power during cruise flight.NTSB CEN13LA388Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Hudson, COThe pilot's improper fuel management, which resulted in the loss of engine power due to fuel starvation.NTSB CEN13LA384Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Heth, ARThe partial collapse of the right main landing gear during landing due to an improper previous weld repair to the right main landing gear and subsequent corrosion, which resulted in a loss of directional control and impact with terrain.NTSB CEN13LA379Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Salisbury, MOThe airplane's reduced braking efficiency and the pilot's subsequent delayed decision to go around, which resulted in a loss of directional control.NTSB CEN13LA377Accident · 1 fatalLimited investigationFinal reportDankelman Peter G RV-7A · Marion, TXThe pilot’s sudden incapacitation and natural death as a result of cardiovascular disease.NTSB CEN13LA362Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Eagle, COThe pilots’ improper fuel management, which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was worn and corroded fuel senders, which transmitted inaccurate fuel readings to the fuel monitoring system.NTSB CEN13IA387Incident · No injuriesIncident investigationFinal reportMartin Charles A Zenith Stol CH 750 · Paragould, ARThe improper installation of the propeller flange, which resulted in an in-flight separation of the propeller assembly.NTSB ANC13FA058Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Cantwell, AKThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.NTSB WPR13WA305Accident · 1 fatalForeign investigationCirrus SR22 · Shepparton, Australia, AustraliaOn June 27, 2013, at 1930 universal coordinated time, a Cirrus Design SR22, VH-CKS, collided with terrain while on approach for landing at Shepparton Aerodrome, Australia. The airplane was operated under the pertinent civil regulations of Australia. The…NTSB WPR13FA294Accident · 1 fatalField investigationFinal reportCessna 172 · Birdseye, UT***This report was modified on August 18, 2015. Please see the docket for this accident to view the original report.*** The operator's improper installation of a supplemental electrical power supply, which caused a short circuit due to inadequate vibration…NTSB CEN13LA380Accident · Minor injuriesLimited investigationFinal reportDiamond Aicraft Industries DA 20-C1 · Odessa, TXThe pilot's use of an improper flap setting and a subsequent inadequate flare of the airplane, which resulted in a bounced landing, and the pilot's delay in executing a go-around.NTSB CEN13LA375Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Colome, SDThe loss of engine power for reasons that could not be determined because a postaccident engine run revealed no anomalies that would have precluded normal operation.NTSB CEN13CA373Accident · No injuriesData collectionFinal reportBeech 200 · Wheeling, ILThe pilot's improper fuel planning and management, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR13LA290Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Casa Grande, AZThe total loss of engine power due to the ingestion of a foreign object and maintenance personnel's failure to remove shop rags before completing the installation of the air inlet barrier system.NTSB WPR13CA354Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · The Dalles, ORThe pilot's failure to see and avoid wires while maneuvering at a low-altitude, which resulted in the main rotor blades striking the wires.NTSB ERA13CA305Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Stevensville, MDThe pilot's failure to maintain directional control during the takeoff. Factors in the accident were the pilot's over-rotation at takeoff, and his failure to abort the takeoff prior to the runway excursion.NTSB CEN13LA376Accident · Serious injuriesLimited investigationFinal reportAvery Jack H Glastar GS-1 · Grand Rapids, MNThe loss of directional control during landing because the autopilot engaged for undetermined reasons because water and recovery damage precluded detailed examination of system components.NTSB CEN13LA374Accident · No injuriesLimited investigationFinal reportAviat A-1B · Ely, MNThe pilot’s failure to maintain control of the amphibious airplane during the water landing.NTSB CEN13LA370Accident · No injuriesLimited investigationFinal reportMooney M20J · El Reno, OKA loss of engine power, which resulted from the failure of the magneto assembly for reasons that could not be determined during postaccident examinations.NTSB WPR13LA287Accident · Serious injuriesLimited investigationFinal reportBell 206B · Royal City, WAThe pilot's failure to maintain clearance from netting material during a low pass over trees, which resulted in a loss of helicopter control.NTSB WPR13LA286Accident · No injuriesLimited investigationFinal reportCessna 182T · San Diego, CABoth pilots’ failure to maintain a proper visual lookout while taxiing during nighttime conditions, which resulted in an on-ground collision.NTSB WPR13FA289Accident · 1 fatalField investigationFinal reportCessna P337H · San Luis Obispo, CALoss of engine power from the rear engine for reasons that could not be determined because of the postimpact thermal damage to the engine. Contributing to the accident were the pilot's decision to continue flight with a known deficiency, his failure to abort…NTSB WPR13FA288Accident · 1 fatalField investigationFinal reportBeech J35 · Helena, MTThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB CEN13CA372Accident · Serious injuriesData collectionFinal reportKubicek BB70Z · Windsor, COThe pilots’ encounter with increased wind, which resulted in a hard and fast landing.NTSB ANC13RA061Accident · No injuriesForeign investigationDe Havilland DHC-2 MK 1 · Half Moon Bay, CanadaOn June 24, 2013, at 1544 coordinated universal time, a DeHavilland DHC-2MK 1, Canadian registered C-FPCG, owned and operated by Seair Seaplanes, was substantially damaged near Half Moon Bay, Canada. Visual meteorological conditions prevailed at the time of…NTSB WPR13LA283Accident · 1 fatalLimited investigationFinal reportExtra 300/LT · Adrian, ORThe pilot's improper decision to conduct low-level maneuvering in a river canyon with power lines, which resulted in his failure to maintain clearance from the power lines.NTSB WPR13FA284Accident · 2 fatalField investigationFinal reportBeech A45 · Boulder City, NVThe pilot/mechanic's loss of control during an emergency descent following a loss of engine power while in cruise flight. Contributing to the accident was the pilot/mechanic's incorrect assembly of the No. 6 cylinder at the last cylinder change, which…NTSB WPR13CA282Accident · No injuriesData collectionFinal reportCessna 170B · Rawlins, WYThe pilot’s delayed decision to abort the takeoff. Contributing to the accident was the pilot's inadequate preflight planning and a high density altitude, which resulted in a runway excursion and collision with terrain.NTSB CEN13LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Campbell, NEThe pilot's decision to continue with the takeoff roll despite the airplane's difficulty becoming airborne The high-density altitude likely contributed to the airplane's reduced performance.NTSB CEN13LA368Accident · 2 fatalLimited investigationFinal reportNanchang China CJ-6 · Wolcott, COThe pilots decision to perform an aerobatic maneuver at a low altitude from which he was unable to recover.NTSB WPR13FA281Accident · 2 fatalField investigationFinal reportPiper PA-30 · Idaho Falls, IDA loss of power to the right engine during the initial climb due to fuel contamination and the pilot's failure to maintain adequate airspeed and airplane control. Contributing to the accident was the pilot's inadequate preflight check of the airplane.NTSB ERA13LA300Accident · Minor injuriesLimited investigationFinal reportSikorsky 269C · Lumberton, NJThe pilot's movement of the throttle to the idle detent at the beginning of a practice autorotation, which was contrary to procedures and resulted in the engine hesitating during the power recovery and a subsequent hard landing.NTSB CEN13LA369Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-15 · Navasota, TXAn inadvertent aerodynamic stall during the approach for landing.NTSB CEN13FA274Accident · 2 fatalField investigationFinal reportBoeing-Stearman IB75A · Dayton, OHThe pilot's controlled flight into terrain. Contributing to the accident was the pilot's modified airshow maneuver, which placed the airplane at low altitude and airspeed and out of position within the performance area.