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 WPR11LA263Accident · No injuriesLimited investigationFinal reportBeech B23 · Jean, NVThe student pilot’s improper in-flight fuel management when he did not switch to the fullest fuel tank when the engine began to lose power, which resulted in fuel starvation and the complete loss of engine power during maneuvering flight. Contributing to the…NTSB WPR11CA264Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the helicopter during taxi, resulting in a loss of tail rotor effectiveness and a subsequent hard landing.NTSB ERA11FA349Accident · 4 fatalField investigationFinal reportCessna T210N · Armonk, NYThe pilot's decision to depart on the flight with a suspected mechanical deficiency and his subsequent decision to fly the final approach at a reduced power setting. Contributing to the accident was the improper timing of the magneto(s) that resulted in a…NTSB ERA11FA348Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Guntersville, ALThe pilot's excessive pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to comply with weight and balance limitations.NTSB ERA11CA372Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Carbondale, PAThe pilot's inadequate recovery from a bounced landing, which resulted in a runway overrun. Contributing to the accident was that the pilot did not attain the proper landing point.NTSB ERA11CA366Accident · No injuriesData collectionFinal reportChampion 7FC · Wellsville, PAThe pilot's failure to maintain adequate airspeed on final approach which resulted in an aerodynamic stall.NTSB ERA11CA356Accident · No injuriesData collectionFinal reportCessna A185F · Trinca, NJThe pilot's failure to maintain directional control, and the flight instructor's inadequate remedial action, which resulted in a ground-loop.NTSB ERA11CA353Accident · No injuriesData collectionFinal reportHead Balloons AX8-88 · Summerdale, ALThe balloon pilot's failure to maintain proper altitude/clearance from a tree line during the landing approach.NTSB CEN11WA463Accident · 1 fatalForeign investigationShannon James A JR Aviat Eagle II · Plock Vistula, PolandNTSB CEN11LA413Accident · No injuriesLimited investigationFinal reportCessna 172N · Bedford Park, ILA loss of engine power due to a fractured push rod precipitated by a stuck exhaust valve.NTSB CEN11LA405Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Faith, SDThe pilot's improper turn while maneuvering during an agricultural application flight, which resulted in an inadvertent aerodynamic stall at low altitude.NTSB CEN11LA402Accident · Serious injuriesLimited investigationFinal reportCessna P210R · Albia, IAThe pilot's inadequate preflight inspection, in which he did not detect that less fuel was on board the airplane than planned, which precipitated a loss of engine power due to fuel exhaustion during initial descent.NTSB CEN11CA411Accident · No injuriesData collectionFinal reportWorley Dennis Sonex · Gardner, KSThe pilot's failure to maintain a proper glide path during the visual approach.NTSB CEN11CA408Accident · No injuriesData collectionFinal reportCessna TU206G · Truth or Consequences, NMThe pilot's inability to control the airplane on take off.NTSB CEN11CA403Accident · No injuriesData collectionFinal reportBell 47G-4A · Montgomery City, MOA loss of control during the precautionary landing, which resulted in inadvertent contact between the main rotor and the tailboom. Contributing to the accident was the overloaded condition.NTSB CEN11CA400Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Charleston, ILThe pilot's selection of unsuitable terrain to take off after making a precautionary landing.NTSB WPR11LA276Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.3 · Jefferson, ORThe pilot's failure to maintain airplane control while on short final after experiencing a downdraft, which resulted in a subsequent hard landing.NTSB ERA11CA351Accident · No injuriesData collectionFinal reportPerth Amboy Bird CK · New Castle, PAThe pilot's improper use of brakes during the landing rollout.NTSB CEN11WA407Accident · 2 fatalForeign investigationPiper PA-39 · Mont Agel, FranceUnder the jurisdiction and control of the French government.NTSB CEN11LA399Accident · 1 fatalLimited investigationFinal reportPiper PA-36-300 · Highmore, SDThe pilot did not maintain control of the airplane while maneuvering at low altitude.NTSB CEN11CA406Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · Shepard, TXthe pilot's loss of aircraft control after encountering windshear and turbulence on takeoff.NTSB CEN11CA398Accident · Serious injuriesData collectionFinal reportLindstrand LBL120A · Le Center, MNThe failure of the passenger to follow the pilot's instructions during landing, which caused the pilot to be ejected from the balloon and sustain serious injuries.NTSB ANC11CA051Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Bethel, AKThe pilot's selection of an unsuitable off-airport landing site, resulting in a nose over during the landing roll.NTSB ANC11CA050Accident · No injuriesData collectionFinal reportCessna 180 · Big Lake, AKThe pilot's failure to maintain the proper glide path during his landing approach, resulting in an undershoot and collision with terrain.NTSB WPR11CA298Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Goodyear, AZThe flight instructor's delayed remedial action and failure to maintain lateral control.NTSB ERA11CA350Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Sterling, MAThe pilot's misjudgment of the amount of flaps required to attain the proper touchdown point. Contributing to the accident was the pilot's limited experience in the high performance glider.NTSB DCA11WA074Incident · No injuriesForeign investigationJohannesburg, South AfricaOn June 16, 2011 at 1301 UTC, ZS-SJO, a Boeing 737-800, operated by South African Airways, sustained a separation of the right nose wheel while taxiing for takeoff at OR Tambo International Airport, Johannesburg, South Africa. A preliminary inspection…NTSB CEN11LA404Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Athleimer, ARFailure of the first stage planetary gearset in the propeller reduction gearbox, which resulted in catastrophic engine failure. Contributing to the failure was the misrepresentation of the gearset being zero-timed by the company that sold the gearset to the…NTSB ANC11CA049Accident · No injuriesData collectionFinal reportChampion 7HC · Kenai, AKThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear, and a nose over.NTSB WPR11CA261Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pullman, WAThe pilot's failure to maintain clearance from power lines while maneuvering.NTSB ERA11LA345Accident · No injuriesLimited investigationFinal reportCessna 525A · Nashville, TNThe pilot-in-command's failure to execute a go-around when the airplane was high and fast on the final approach.NTSB ERA11LA344Accident · No injuriesLimited investigationFinal reportBeech A100 · Gray, TNAn encounter with convectively-induced turbulence and icing, which resulted in an in-flight upset and a loss of airplane control.NTSB ERA11CA347Accident · No injuriesData collectionFinal reportCessna 172N · Belle Glades, FLThe pilot’s failure to maintain airplane control during the landing approach.NTSB CEN11LA397Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDThe student pilot's inadequate recovery from an autorotation and the CFI's delayed remedial action.NTSB ANC11CA053Accident · No injuriesData collectionFinal reportPiper PA-18A · McCarthy, AKThe pilot's failure to maintain control of the airplane while taxiing in gusty wind conditions.NTSB WPR11LA260Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Buttonwillow, CAThe pilot's misjudgment of the landing approach and subsequent long landing and overrun of the runway resulting in a collision with ground obstacles. Contributing to the accident was the pilot's likely fatigue and dehydration.NTSB WPR11CA296Accident · Minor injuriesData collectionFinal reportCessna 188 · Glasgow, MTThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB OPS11IA653Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fairbanks, AKInadequate air traffic control actions that failed to establish and maintain required separation between the two airplanes. Contributing to the incident was inexperience on the part of the local controller, inadequate oversight by the tower…NTSB ERA11LA342Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Linden, NCA partial loss of engine power during initial climb for undetermined reasons.NTSB ERA11CA343Accident · No injuriesData collectionFinal reportCessna 172S · Covington, GAThe pilot's failure to maintain directional control during takeoff.NTSB CEN11CA395Accident · No injuriesData collectionFinal reportNelson Dan H LONG-EZ · Moriarity, NMThe pilot's failure to maintain directional control during the landing.NTSB CEN11CA392Accident · No injuriesData collectionFinal reportCessna 172S · Cortez, COThe pilot's failure to maintain aircraft control while landing in gusty crosswind conditions.NTSB ANC11CA047Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's loss of directional control while landing in a crosswind.NTSB CEN11LA386Accident · No injuriesLimited investigationFinal reportCessna 172S · Grand Forks, NDThe flight instructor’s delayed remedial action to the student pilot’s bounced landing and subsequent loss of aircraft control.NTSB CEN11LA385Accident · No injuriesLimited investigationFinal reportWiley C W RV-6A · Colgate, OKThe loss of engine power for undetermined reasons.NTSB CEN11FA383Accident · Minor injuriesField investigationFinal reportBoeing B-17G · Oswego, ILAn inadequate repair of the fuel tank that allowed the fuel leak to continue, ultimately resulting in an in-flight fire.NTSB WPR11FA258Accident · No injuriesField investigationFinal reportBowley Murphy · Aguila, AZA fire that originated from a fuel leak at an undetermined location in the engine compartment. Contributing to the accident was the builder's use of non-aviation hardware for engine fluid fittings and lines.NTSB WPR11CA257Accident · No injuriesData collectionFinal reportMooney M20K · Page, AZThe pilot's selection of the wrong taxi route and failure to follow prescribed taxi procedures.NTSB ERA11CA341Accident · Minor injuriesData collectionFinal reportCessna 182K · Bentonia, MSThe pilot’s loss of control on the ground during engine start, which resulted in a collision with nearby equipment. Contributing to the accident was the pilot’s improper engine start procedure and improper securing of the seat.NTSB ERA11CA340Accident · No injuriesData collectionFinal reportMooney M-20G · Monroeville, PAThe pilot’s failure to maintain airplane control during takeoff.