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 CHI07CA265Accident · No injuriesData collectionFinal reportMooney M20-C · Hicksville, OHThe pilot failed to execute a go-around.NTSB ATL07LA112Accident · Serious injuriesLimited investigationFinal reportFalcon Safety Craft Falcon XP · Montgomery, NYA total loss of engine power during initial climb for undetermined reasons.NTSB SEA07FA228Accident · 1 fatalField investigationFinal reportCessna T210G · Lomita, CAThe loss of engine power during approach as a result of fuel starvation due to the pilot's improper pre takeoff fuel system selector valve positioning. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA07CA232Accident · No injuriesData collectionFinal reportCirrus Design SR22 · San Diego, CAThe pilot's improper recovery from a bounced landing, which resulted in porpoising and collapse of the nose landing gear.NTSB SEA07CA227Accident · Minor injuriesData collectionFinal reportMapes Kitfox V · Silverdale, WAThe pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in an inadvertent stall and uncontrolled descent to terrain impact.NTSB NYC07LA189Accident · Minor injuriesLimited investigationFinal reportStout Gordon Glasair III · Captiva, FLA loss of engine power for undetermined reasons.NTSB MIA07LA132Accident · Minor injuriesLimited investigationFinal reportRoger A Dalke E.B. Jenny · Wakefield, VAThe pilot/owner's inadequate maintenance which resulted in a radiator leak, a loss of engine coolant, the engine overheating, and partial loss of engine power.NTSB DFW07LA172Accident · No injuriesLimited investigationFinal reportCessna 172C · Pascagoula, MSThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07LA266Accident · No injuriesLimited investigationFinal reportCessna 172M · Marine City, MIA loss of engine power for undetermined reasons. Factors contributing to the accident were the insufficient runway remaining and the soft terrain.NTSB CHI07CA269Accident · No injuriesData collectionFinal reportAviat A-1 · Kellys Island, OHThe directional control not obtained/maintained by the pilot during landing. Contributing factors were the pole, hangar, and crosswind.NTSB CHI07CA263Accident · Minor injuriesData collectionFinal reportCessna 180 · Princeton, MNThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A factor was the fuel siphoning from the right fuel tank.NTSB ATL07WA113Accident · No injuriesForeign investigationGates Learjet 35A · Melville Hall, DominicaNTSB ANC07TA080Accident · No injuriesFinal reportPiper PA-18 · McGrath, AKThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was rough and uneven terrain conditions.NTSB ANC07LA079Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Big Lake, AKThe student pilot's failure to maintain adequate airspeed to avoid an inadvertent stall while maneuvering.NTSB SEA07FA231Accident · 1 fatalField investigationFinal reportSchempp-Hirth Ventus-CM · Benton, CAThe pilot's failure to maintain aircraft control while maneuvering and the inadvertent entry into a stall/spin. Contributing to the accident were the mountainous terrain conditions, unfavorable wind conditions, and the terrain-induced turbulent wind…NTSB SEA07CA225Accident · No injuriesData collectionFinal reportCessna 182P · Bremerton, WAThe pilot's failure to maintain airspeed during the landing flare. A factor was the encounter of the stall and subsequent hard landing.NTSB LAX07LA245Accident · Minor injuriesLimited investigationFinal reportBurnham Avid Flyer · Sequim, WAa loss of engine power due to a dual ignition system failure.NTSB LAX07CA247Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Chino, CAThe private pilot's failure to maintain the proper airspeed and main rotor rpm, which resulted in a high rate of descent and subsequent hard landing. Also causal was the certificated flight instructor's delayed remedial action.NTSB DFW07LA206Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Mason County, TXThe loss of control as result of the collapsed right main landing gear during the landing roll. A contributing factor was the failure of the right main gear as result of corrosion.NTSB CHI07LA260Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · West Bend, WIThe pilot's decision to depart in adverse weather conditions, and his failure to maintain clearance from the terrain. Contributing to the accident included the pilot's lack of an instrument rating, his lack of recent night experience, the night conditions and…NTSB CHI07CA276Accident · No injuriesData collectionFinal reportGolden Eagle Chief · Hindsboro, ILThe loss of engine power due to the number seven cylinder's separation during cruise and the crops encountered during the forced landing leading to the airplane nosing over.NTSB CHI07CA264Accident · No injuriesData collectionFinal reportCessna 182 · Jasper, MNThe loss of engine power due to fuel starvation as a result of the pilot's inadequate preflight. The false indication of the fuel remaining in the fuel tanks and the corn crop were factors.NTSB CHI07CA261Accident · No injuriesData collectionFinal reportCessna 210 D · Fort Wayne, INThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight.NTSB ANC07LA100Accident · No injuriesLimited investigationFinal reportCessna 185 · Pedro Bay, AKThe loss of control during the landing roll for an unknown reason.NTSB SEA07CA226Accident · No injuriesData collectionFinal reportEagle Eagle DW-1 · Waterville, WAThe loss of engine power during takeoff for an undetermined reason. A contributing factor was the high vegetation in the field where the airplane came to rest.NTSB MIA07LA131Accident · No injuriesLimited investigationFinal reportMBB BK-117 A-4 · Ridgeville, SCThe EMS helicopter pilot's failure to ensure adequate obstacle clearance which resulted in the tail rotor impacting a tree during the takeoff.NTSB DEN08WA039Accident · 20 fatalForeign investigationde Havilland DHC6-33 · Moorea, French PolynesiaNTSB CHI07CA270Accident · No injuriesData collectionFinal reportMooney M20J · Chesterfield, MOThe pilot failed to maintain directional control while taxiing after landing. A factor was the runway sign.NTSB CHI07CA267Accident · No injuriesData collectionFinal reportSnow S-2C · Hazelton, NDThe loss of engine power for undetermined reasons.NTSB CHI07CA259Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Creston, IAThe loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel calculations.NTSB ATL07LA111Accident · 1 fatalLimited investigationFinal reportPiper PA-22-160 · Leonardtown, MDThe pilot's inadequate performance planning and failure to abort the takeoff.NTSB ANC07LA077Accident · No injuriesLimited investigationFinal reportCessna 185 · Bethel, AKThe improper [reversed] installation of the fuel selector handle by maintenance personnel.NTSB SEA07CA224Accident · No injuriesData collectionFinal reportCessna 421B · Oceanside, CAThe collapse of the right main landing gear during the landing roll for undetermined reason, which resulted in a loss of directional control and collision with a fence.NTSB NYC07LA187Accident · Serious injuriesLimited investigationFinal reportCessna T337G · Chamblee, GAThe pilot’s failure to utilize all of the power available following an engine failure. Contributing to the accident were the failure of the rear engine for undetermined reasons.NTSB DFW07CA181Accident · Serious injuriesData collectionFinal reportCessna A188B · Garden City, TXThe pilot's failure to maintain clearance with the ground equipment while maneuvering. A contributing factor was the power lines along the pilot's application path.NTSB CHI07CA262Accident · No injuriesData collectionFinal reportBeech BE-77 · Bloomington, INThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight.NTSB ANC07CA076Accident · No injuriesData collectionFinal reportMaule M-5-235 · Talkeetna, AKThe flight instructor's inadequate supervision of the student while landing, which resulted in an undershoot and an in-flight collision with an object. Factors contributing to the accident are the dual student's misjudged altitude/distance and delayed…NTSB ANC07CA075Accident · No injuriesData collectionFinal reportCessna 180 · Skwentna, AKThe failure of the left brake, and the pilot's continued operation with a known defect (the left brake), which resulted in a loss of control during the landing roll, and an on ground encounter with terrain. A contributing factor to the accident was the…NTSB NYC07LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Warrenton, VAThe flight instructor's failure to maintain adequate rotor rpm during touchdown.NTSB LAX07CA242Accident · No injuriesData collectionFinal reportCessna 172B · Sisters, ORThe pilot's failure to maintain adequate clearance from trees.NTSB CHI07LA252Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Knox, INThe in-flight encounter with turbulence.NTSB ANC07CA074Accident · No injuriesData collectionFinal reportPiper PA-18 · King Salmon, AKThe pilot's inadequate compensation for a crosswind during the takeoff roll, which resulted in a loss of control, and an on-ground encounter with terrain. A factor in the accident was a crosswind.NTSB LAX07CA244Accident · No injuriesData collectionFinal reportBeech 36 · Jean, NVA loss of engine power for undetermined reasons.NTSB DEN07MA134Accident · 5 fatalMajor investigationFinal reportBeech E90B · Ruidoso, NMFailure to maintain clearance from terrain due to spatial disorientation.NTSB ANC07FA073Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Sitka, AKThe pilot's failure to maintain altitude/distance from obstacles during an IFR circling approach, and his failure to follow the instrument approach procedure. Contributing to the accident was clouds.NTSB LAX07FA241Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · S. Lake Tahoe, CAThe pilot's inadequate preflight planning/decision, and his failure to maintain clearance from trees during takeoff-initial climb. Contributing to the accident were turbulence, downdrafts, and rising terrain.NTSB LAX07CA259Accident · Serious injuriesData collectionFinal reportSix Chutter SR7 · Toledo, WAA hard landing following the pilot's in-flight loss of control.NTSB CHI07WA257Accident · 4 fatalForeign investigationPiper PA-28-140 · Sandown, United KingdomNTSB CHI07CA258Accident · No injuriesData collectionFinal reportAeronca 7AC · Westerly, RIThe pilot's failure to maintain control of the airplane during landing which resulted in the overload failure of the right main landing gear. The overload failure of the right main landing gear was a factor.NTSB CHI07CA250Accident · Minor injuriesData collectionFinal reportGrumman G-164A · Vinton, IAThe pilot failed to maintain clearance from the power line while maneuvering during an aerial application flight. A factor was the power line.