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 FTW04FA168Accident · 3 fatalField investigationFinal reportBell 206-L1 · Vermillion Bay, LAThe pilot's continued flight into adverse weather conditions resulting in a loss of control. Contributing factors were the prevailing thunderstorms and the pilot's inadequate in flight preparation and planning.NTSB FTW04CA177Accident · No injuriesData collectionFinal reportMooney M20R · Kerrville, TXThe pilot's failure to compensate for existing wind conditions. Contributing factors were the gusty high winds.NTSB ANC04LA067Accident · No injuriesLimited investigationFinal reportRufli Theodore J Rufli · Fairbanks, AKThe loss of engine power for an undetermined reason during takeoff-initial climb, which resulted in a forced landing and an on ground collision with a parked and unoccupied airplane.NTSB SEA04LA115Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Deer Park, WAThe flight instructor's delayed remedial action. Factors include the owner/pilot's failure to maintain directional control during the landing roll, and a warped/realigned fuselage that contributed to the sensitivity of the aircraft's response to pilot rudder…NTSB SEA04LA114Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Medford, ORThe pilot's failure to maintain clearance from a tree while maneuvering. Trees were a factor.NTSB NYC04CA146Accident · No injuriesData collectionFinal reportCessna 172P · Springfield, OHThe pilot's failure to maintain adequate airspeed resulting in a stall and hard landing.NTSB LAX04TA248Accident · Minor injuriesFinal reportBell 206B · Lancaster, CAThe pilot's misjudged autorotative flare and the flight instructor's delayed remedial action and inadequate supervision of the flight.NTSB LAX04CA246Accident · No injuriesData collectionFinal reportSchweizer 1-35 · Sparks, NVthe pilot's misjudgment of altitude and distance resulting in an undershoot of the runway.NTSB FTW04LA166Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Crowley, LAThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN04LA093Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Heber City, UTthe pilot's failure to maintain aircraft control during the aborted landing. Contributing factors were the pilot's failure to maintain runway alignment, the fence, and the ditch.NTSB CHI04CA169Accident · Minor injuriesData collectionFinal reportBellanca 8GCBC · Mankato, MNThe pilot's improper decision to initiate the flight given the crosswind wind condition. Additional causes were the pilot's inadequate compensation for the crosswind and his subsequent failure to maintain aircraft control. The crosswind and the runway light…NTSB CHI04CA163Accident · No injuriesData collectionFinal reportGrumman G-164A · Hutchinson, MNThe pilot's failure to maintain airspeed during the low altitude turn after takeoff. A factor to the accident was the low altitude and the swampy terrain condition.NTSB CHI04CA162Accident · No injuriesData collectionFinal reportAir Tractor AT-401 · Britton, SDThe loss of engine power due to a stuck exhaust valve and the unsuitable terrain encountered during the forced landing. A factor to the accident was the soft terrain condition.NTSB ATL04FA139Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Fort Lauderdale, FLThe pilot's inadequate preflight planning which resulted in the loss of engine power due to fuel exhaustion, and the pilot's failure to maintain flying speed which resulted in an inadvertent stall, and the subsequent collision with a building.NTSB NYC04FA144Accident · 1 fatalField investigationFinal reportCessna P210N · Dunkirk, NYThe pilot's loss of aircraft control and the subsequent overstress and separation of the wing during an encounter with convection induced turbulence.NTSB ATL04TA137Accident · No injuriesFinal reportBell 206B · Graysville, ALThe pilot's inadequate compensation for a tailwind and his failure to maintain directional control resulting in a loss of tail rotor effectiveness. A factor was the pilot's improper in-flight decision to hover with a tailwind.NTSB SEA04LA113Accident · Serious injuriesLimited investigationFinal reportPiper J-3 · Glenoma, WAThe pilot's failure to maintain clearance from the trees while maneuvering at a very low level in hilly terrain. Factors include hilly terrain, and thickly forested slopes in the area where the pilot was maneuvering.NTSB SEA04FA111Accident · 1 fatalField investigationFinal reportTeST TST-10 M · Enumclaw, WAAircraft control not maintained while maneuvering for landing. A proper glidepath was not maintained was a factor.NTSB SEA04CA116Accident · No injuriesData collectionFinal reportChampion 7GCB · Florence, ORPilot's improper touchdown point during landing. A sand mound was a factor in the accident.NTSB NYC04CA145Accident · No injuriesData collectionFinal reportCessna 172R · Hartford, CTThe student pilot's improper flare and inadequate compensation for wind conditions. A factor was the gusty winds.NTSB MIA04WA101Accident · Serious injuriesForeign investigationDouglas DC-3 · Vichada, ColombiaNTSB MIA04FA100Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Baker, FLThe flight crew's inadvertent flight into thunderstorms resulting in the design limits of the airplane being exceeded, loss of aircraft control and subsequent in-flight breakup. A factor in the accident was the lack of required advisory by ATC about a radar…NTSB CHI04LA146Accident · 1 fatalLimited investigationFinal reportCessna A188B · Prosser, NEThe pilot's abrupt maneuver to avoid obstructions, and his failure to maintain adequate airspeed resulting in a stall. The low altitude flight operation, and the transmission tower (antenna) were contributing factors.NTSB ANC04LA066Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop/swerve, and the left wingtip and propeller striking the runway. A factor associated with the accident was the installation of oversized tires on the…NTSB WAS06WA017Accident · 6 fatalForeign investigationCessna 185 · Sukabumi, IndonesiaNTSB SEA04LA112Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Bandera, WAThe pilot's failure to maintain clearance from an airport sign during the landing roll. Inadequate compensation for the wind gust and the sign were factors.NTSB NYC04WA149Accident · No injuriesForeign investigationBeech 24 · Baden, GermanyNTSB MIA04LA099Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Deland, FLA loss of engine power due to an engine master rod bearing failure for undetermined reasons, resulting in damage to the airplane during the subsequent forced landing.NTSB CHI04CA164Accident · No injuriesData collectionFinal reportCessna 401 · Mt. Vernon, ILThe pilot's misjudgment of the landing flare. Contributing factors were the pilot's failure to execute a stabilized approach for landing. An additional factor was the presence of the runway lights.NTSB CHI04CA160Accident · Minor injuriesData collectionFinal reportChampion 7FC · Carmi, ILThe pilot's failure to maintain directional control during the takeoff roll, his decision to continue the takeoff when the aircraft had left the runway surface, and his selection of unsuitable terrain for the continued takeoff. An additional cause was the…NTSB ATL04CA136Accident · Serious injuriesData collectionFinal reportBeech A23 · Columbia, TNThe pilot's failure to maintain clearance from trees during climb and the pilot's failure to execute a go-around before completing the approach to land.NTSB ATL04CA135Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Gulf Shores, ALThe pilot's failure to maintain airspeed that resulted in a stall and the subsequent collision with the ground.NTSB LAX04CA244Accident · No injuriesData collectionFinal reportFairchild 24R-40 · Lincoln, CAthe pilot's failure to maintain directional control and inadequate compensation for gusty wind conditions, which resulted in a ground loop and collision with the runway.NTSB CHI04LA158Accident · 2 fatalLimited investigationFinal reportMonocoupe 90AL-115 · St. Paul, MOThe pilot's failure to maintain altitude/clearance from the terrain while maneuvering.NTSB CHI04CA159Accident · Serious injuriesData collectionFinal reportBracken CB540 · Lapeer, MIThe pilot's loss of control due to an undetermined flight control system malfunction. Contributing factors to the accident were the wires and trees.NTSB ATL04CA134Accident · Minor injuriesData collectionFinal reportCessna T210N · Ellijay, GAThe pilot misjudged his airspeed, distance and intended proper touchdown point which resulted in an overrun of the runway surface and the subsequent collision with an embankment.NTSB ATL04CA133Accident · No injuriesData collectionFinal reportCessna 172 · Kennesaw, GAThe student pilot's failure to maintain directional control during landing roll that resulted in the on ground collision with the ground, and the subsequent collapse of the nose gear.NTSB SEA04LA110Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL · Mountain Home, IDThe pilot's failure to maintain aircraft control during an undetermined in-flight operational phase resulting in an uncontrolled descent into the terrain. Factors include strong gusty winds in the area of the accident.NTSB NYC04CA143Accident · No injuriesData collectionFinal reportStearman 4E · Loganton, PAThe pilot's failure to maintain aircraft control during the landing roll, which resulted in a nose over. A factor was uneven terrain.NTSB MIA04WA110Accident · No injuriesForeign investigationCessna 402B · Bonaire, NTNTSB IAD04FA025Accident · 2 fatalField investigationFinal reportRobinson R-44 · Killingly, CTThe pilot in command's intentional flight into instrument meteorological flight conditions, and his failure to maintain obstacle clearance which resulted in a controlled descent into trees. Factors included the pilot's inadequate weather evaluation, low cloud…NTSB SEA04CA109Accident · Serious injuriesData collectionFinal reportBalloon Works Fire Fly 9 · Aurora, ORPilot's failure to compensate for wind conditions. Wind was a contributing factor.NTSB LAX04GA243Accident · 1 fatalFinal reportWSK PZL Mielec M-18A · St. George, UTThe pilot's failure to maintain an adequate airspeed margin, resulting in a stall and loss of control.NTSB LAX04CA242Accident · No injuriesData collectionFinal reportVans RV-9A · The Sea Ranch, CAthe pilot's inadequate compensation for gusty crosswind conditions and failure to maintain proper runway alignment, resulting in a collision with trees.NTSB FTW04LA164Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe separation of the right main landing gear wheel and axle during take-off. Contributing factors were the fatigue of the bolts on the right main landing gear and the rough and uneven terrain.NTSB CHI04FA157Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Great Bend, KSThe pilot's inadequate preflight planning due to his failure to obtain a weather briefing prior to takeoff. Additional causes were the pilot's inadvertent flight into adverse weather and his failure to maintain clearance with the terrain during his attempt to…NTSB SEA04LA108Accident · No injuriesLimited investigationFinal reportCessna 421B · Bend, OROn ground encounter with terrain during the takeoff roll as a result of the left side brake not operating. Inadequate maintenance inspection, overload of the nose landing gear and soft terrain were factors.NTSB SEA04FA106Accident · 1 fatalField investigationFinal reportNorth American SNJ 5 · Oroville, WAThe pilot's failure to maintain adequate terrain clearance, which resulted in the in-flight collision with terrain. Rising terrain was a factor.NTSB SEA04CA107Accident · No injuriesData collectionFinal reportSteward Rocky 162F · Hood River, ORThe pilot's miscalculation of fuel consumption and his inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor was the high vegetation.NTSB SEA04CA105Accident · No injuriesData collectionFinal reportFetherolf Hatz CB-1 · Nampa, IDThe pilot's failure to maintain directional control of the tail wheel aircraft during an aborted landing. Factors include a slight tailwind, and a mound (berm) of earth in the area where the aircraft departed the side of the runway.