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 ANC93LA141Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bernard Glacier, AKImproper planning/decision by the pilot, concerning the landing at the remote strip, which resulted in a nose over, while using heavy brakes to stop. A factor related to the accident was: the rough/uneven condition of the landing strip.NTSB SEA93LA171Accident · No injuriesLimited investigationFinal reportCessna 188 · Marion, MTThe premature liftoff for takeoff by the pilot and the inadvertant stall/mush. A factor relating to the accident was the high density altitude.NTSB NYC93LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Fryeburg, METhe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose gear and the subsequent nose over. A factor was an improper flare.NTSB LAX93FA316Accident · Serious injuriesField investigationFinal reportBell 206L1 · Tusayan, AZFailure of the pilot of N444CR to maintain adequate main rotor clearance from N38903, and the operator's failure to provide adequate or recommended safe helipad dimensions. A factor in the accident was the lack of visual reference to the rotating blades of…NTSB DEN93FA101Accident · Serious injuriesField investigationFinal reportThunder and Colt 240A · Woody Creek, COAn inflight encounter with high winds which required a precautionary landing.NTSB DEN93FA100Accident · 6 fatalField investigationFinal reportCameron N-145 · Woody Creek, COFailure by the pilot in command to maintain proper altitude and visual lookout. A factor was high wind.NTSB CHI93LA319Accident · No injuriesLimited investigationFinal reportPiper J-2 · Warrensburg, MOthe pilot's inadequate preflight planning and preparation. A factor in the accident was the downdraft near the end of the runway.NTSB CHI93LA297Accident · No injuriesLimited investigationFinal reportBeech 95-B55B · Lafayette, INthe loss of engine power for reason or reasons undetermined.NTSB CHI93DEV01Accident · 1 fatalFinal reportWalter D. Courtney Courtney TWO · Canton, ILthe pilot's failure to maintain control of the airplane during final approach to landing.NTSB BFO93WA144Accident · 3 fatalForeign investigationMooney M20J · Celle-Arloh, GermanyNTSB ANC93LA140Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Near Skwentna, AKThe pilot in command's inadequate preflight planning and preparation. A factor in the accident was the pilot's lack of familiarity with the particular aircraft's performance.NTSB ANC93LA139Accident · No injuriesLimited investigationFinal reportCessna 170 · Northway, AKThe pilot-in-command's inadequate compensating for the variable wind conditions.NTSB ANC93LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe inadvertent raising of the flaps.NTSB SEA93LA174Accident · 2 fatalLimited investigationFinal reportBrauch Glasair · Blanding, UTThe loss of engine power resulting from inadequate maintenance inspection by the pilot, a leak from loose fuel system line fittings, and fuel exhaustion. A factor relating to the accident was the rough/uneven terrain.NTSB NYC93LA146Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Leeds, METhe loss of engine power for undetermined reasons.NTSB NYC93FA145Accident · 2 fatalField investigationFinal reportCurtiss-Wright Travel AIR 4000 · Marlboro, NJThe loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and inflight collision with the terrain.NTSB MIA93LA172Accident · No injuriesLimited investigationFinal reportLove, Sanford W. Dominator · Okeechobee, FLThe failure of the pilot in command to maintain rotor speed while reversing direction.NTSB LAX93FA315Accident · 2 fatalField investigationFinal reportBeech E35 · Big Bear, CAA loss of engine power due to unporting of the selected main fuel tank at a critical time, which was caused by the pilot's failure to follow the directives in the flight manual regarding prolonged turns or slips with less than 10 gallons in the selected tank.NTSB CHI93LA314Accident · No injuriesLimited investigationFinal reportCessna 188 · Martin, SDthe pilot's failure to maintain control of the airplane during the takeoff roll.NTSB CHI93LA298Accident · No injuriesLimited investigationFinal reportCessna 182P · Buffalo, SDThe pilot-in-command's premature lift-off and subsequent stall/mush into rough/uneven terrain.NTSB ATL93LA142Accident · 1 fatalLimited investigationFinal reportWM. D. Butterill Mustang M1 · Wadesboro, NCThe pilot's intentional flight into IMC without the proper instrumentation, which resulted in the pilot's loss of aircraft control, and in flight breakup of the airplane.NTSB ATL93FA143Accident · 4 fatalField investigationFinal reportBeech C-90 · Augusta, GAWas the pilot's failure to adequately evaluate inflight weather conditions which resulted in a loss of control when the airplane encountered a thunderstorm.NTSB ANC93LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Northway, AKThe failure of the pilot to maintain directional control on touchdown. A factor in the accident was the gusty crosswind conditions.NTSB ANC93LA136Accident · No injuriesLimited investigationFinal reportLake LA04 · Blair Lake, AKThe pilot's inadvertant entry into a porpoise and subsequent loss of control while step-taxiing prior to takeoff. A factor in the accident was the rough water conditions.NTSB LAX93LA314Accident · No injuriesLimited investigationFinal reportMooney M20J · King City, CAthe pilot's loss of directional control during the takeoff ground roll due to the inadvertent interference with the controls by a passenger.NTSB FTW93LA233Accident · Minor injuriesLimited investigationFinal reportAero Falcon Intl. Knight Falcon · Mineral Wells, TXFailure of the autopilot which resulted in an improper flight control condition. A factor was the pilot's inability to regain control.NTSB FTW93LA232Accident · No injuriesLimited investigationFinal reportCessna 182A · Killeen, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty crosswinds.NTSB FTW93LA231Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Salida, COThe climb capability of the airplane being exceeded and the pilot's decision to turn into the rising terrain. A factor was the high density altitude.NTSB DEN93FA099Accident · 6 fatalField investigationFinal reportPiper PA-32-300 · Delight, ARThe failure of the vacuum pump, and an inoperative turn coordinator. Factors which contributed to the accident were: the pilot's loss of control of the airplane as a result of spatial disorientation, the pilot exceeding the design stress limits of the…NTSB CHI93LA313Accident · No injuriesLimited investigationFinal reportCessna 150M · Blue Rapids, KSthe loss of engine power for an undetermined reason.NTSB CHI93LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Millard, NEImproper maintenance/inspection of the aircraft by (other) maintenance personnel, and subsequent blockage of the induction air system by an object (alternate air door) that was not removed during previous maintenance.NTSB CHI93LA308Accident · No injuriesLimited investigationFinal reportBeech 19A · Ludington, MIthe pilot's misjudged landing flare.NTSB ANC93LA135Accident · No injuriesLimited investigationFinal reportLuscombe SL8 · Dillingham, AKThe pilot-in-command's selection of unsuitable terrain for landing. A factor was the soft terrain.NTSB MIA93LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Cape Canaveral, FLLoss of engine power for an undetermined reason.NTSB FTW93FA229Accident · 1 fatalField investigationFinal reportCessna 152 · Houston, TXCompany management's dispatch of an airplane with known deficiencies, their failure to correct the deficiencies, and the student pilot's inadvertent entry into a stall. Factors which contributed to the accident were: chafed wiring, fouled spark plugs, a…NTSB CHI93LA309Accident · Minor injuriesLimited investigationFinal reportTaylorcraft L2B · Friedenberg, MNthe pilot's decision to fly the airplane with know deficiencies which resulted in a restricted fuel flow to the engine.NTSB CHI93DEE04Accident · 1 fatalFinal reportDarst KR-1 · Oregon, ILthe partial separation of the elevator control cable.NTSB MIA93LA170Accident · No injuriesLimited investigationFinal reportRobinson R22 B · Miami, FLThe commercial rated student pilot's failure to insure the instructor had taken control of the helicopter and the flight instructors failure to properly supervise the student which resulted in the student letting go of the controls while in a hover.NTSB MIA93LA169Accident · No injuriesLimited investigationFinal reportAyres S2R-T15 · Louise, MSThe pilot in commands decision to takeoff from a road with a left quartering tailwind which resulted in his loosing directional control and the aircraft colliding with a utility pole.NTSB LAX93LA313Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC-12D · Tehachapi, CAFuel starvation due to the pilot's failure to correctly position the fuel selector prior to departure, and his failure to maintain an adequate airspeed margin above stall while attempting to return to the runway. Factors in the accident were: the pilot's…NTSB FTW93LA230Accident · No injuriesLimited investigationFinal reportAero Commander S2R · England, ARA partial loss of engine power for undetermined reasons.NTSB FTW93LA228Accident · No injuriesLimited investigationFinal reportBell 206B · Pearland, TXPilot's failure to maintain proper rotor RPM, the delayed flare, and improper touchdown. Factors were total failure of the power turbine due to oil starvation to the #8 bearing assembly.NTSB CHI93LA310Accident · No injuriesLimited investigationFinal reportCessna 177RG · Emporia, KSThe pilot's selection of unsuitable terrain.NTSB CHI93DEP03Accident · No injuriesFinal reportKit Fox IV · Green Bay, WIthe improper modification of the fuel system by the pilot-in-command. A factor was bockage of the fuel system screen.NTSB ANC93FA134Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Atigun Pass, AKThe pilot-in-command's intentional VFR flight into instrument meteorological conditions and his unfamiliarity with the geographical area. Factors were the rain and fog.NTSB NYC93LA144Accident · No injuriesLimited investigationFinal reportBeech A55 · Norfolk, VAThe pilot's improper compesnation for wind conditions and failure to maintain firectional control. A factor was adverse wind conditions.NTSB NYC93LA142Accident · No injuriesLimited investigationFinal reportCessna 152L · East Berne, NYthe pilot's inadequate preflight planning for a departure from a short field and his failure to attain a proper climb rate, resulting in an in-flight collision with a 5 foot pole located on rising terrain, 20 feet above the airport elevation.NTSB NYC93LA141Accident · Minor injuriesLimited investigationFinal reportGera Nieuport II · Somerville, NJThe loss of engine power for undetermined reasons.NTSB NYC93FA140Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Provincetown, MAThe pilot initiating VFR flight into instrument meteorological conditions resulting in spatial disorientation and loss of aircraft control. During his attempt to regain control of the aircraft the pilot exceeded the design stress limits resulting in wing…NTSB FTW93LA226Accident · Serious injuriesLimited investigationFinal reportSukane KR-2 · Clines Corners, NMThe pilot's inadvertent VFR flight into IMC and failure to maintain proper altitude. Factors were fog, rain, and the pilot's failure to obtain a weather brief.