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 NYC05CA076Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Indian Head, MDThe pilot's failure to maintain adequate altitude/clearance while on final approach, which resulted in an in-flight collision with trees. A factor in this accident was the gusty wind conditions.NTSB LAX05LA149Accident · 2 fatalLimited investigationFinal reportSchlitter Randy J Rans S6ES Coyote II · Tombstone, AZloss of engine power for undetermined reasons and the flying pilot's failure to maintain an adequate airspeed that resulted in a stall and uncontrolled descent into terrain.NTSB LAX05CA148Accident · No injuriesData collectionFinal reportCessna 172N · Palo Alto, CAThe student's failure to maintain directional control and the CFI's failure to adequately supervise the flight.NTSB IAD05TA058Accident · Minor injuriesFinal reportHughes 369FF · Quantico, VAThe flight crew's failure to maintain adequate altitude/clearance from a building, which resulted in contact with the building, dynamic rollover, and collision with terrain.NTSB DFW05CA109Accident · No injuriesData collectionFinal reportRobinson R22 · Bandera, TXThe pilot's loss of control while hovering after encountering settling with power.NTSB CHI05CA107Accident · No injuriesData collectionFinal reportWhittman Tailwind · Lyndon, KSThe pilot improper recovery from a bounced landing, and his inadequate compensation for a tailwind, which resulted in a loss of control and subsequent collision with the ground. Contributing to the accident was the pilot's selection of a wrong runway, the…NTSB ANC05CA069Accident · No injuriesData collectionFinal reportCessna 170 · Anchorage, AKThe pilot's failure to maintain clearance from a sign while taxiing from landing, which resulted in an on ground collision with the sign.NTSB ANC05CA066Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's selection of an unsuitable landing area, which resulted in an on ground encounter with terrain during the landing roll, and subsequent nose down of the airplane. A factor associated with the accident was soft terrain.NTSB ENG05WA009Incident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Buenos Aires, ArgentinaNTSB DFW05LA110Accident · Minor injuriesLimited investigationFinal reportFriddle Super Cub Replica · Springtown, TXThe pilot's failure to compensate for wind conditions and his failure to maintain aircraft control during a go-around, which resulted in collision with trees.NTSB CHI05FA180Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Lake Michigan, WIThe pilot's inaccurate preflight planning and his delayed en route decision to make a fuel stop, which resulted in the loss of engine power due to fuel exhaustion and subsequent ditching.NTSB ATL05LA075Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-26AT · Lawrenceville, GAThe pilot's improper landing flare that resulted in a hard landing.NTSB SEA05CA086Accident · No injuriesData collectionFinal reportWilliams Helicopter UH-1B · Uniontown, WAThe pilot's failure to maintain clearance from an object while maneuvering, which resulted in the main rotor blades striking a power pole. The power pole was a factor in the accident.NTSB MIA05LA098Accident · Serious injuriesLimited investigationFinal reportGordon E. Brown Nieuport C-1 · Homestead, FLThe reported loss of engine power for undetermined reasons on the downwind leg which resulted in a forced landing, and subsequent in-flight collision with a guy-wire and terrain.NTSB MIA05CA097Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Pensacola, FLThe pilot misjudged his altitude and distance resulting in an overrun. Also causal was the pilot's failure to execute a go-around.NTSB DFW05CA108Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH-2000 · Panhandle, TXThe student pilot's improper compensation for existing wind conditions. Contributing factors were the crosswind and inadequate supervision by the flight instructor.NTSB DEN05IA071Incident · No injuriesIncident investigationFinal reportBoeing 737-282 · Denver, COthe improper operation of the loading bridge which resulted in the loading bridge impacting the airplane. Contributing factors were the failure of the ground personnel to marshal the airplane on the assigned aircraft stop line, lack of supervision and…NTSB CHI05CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · South Bend, INThe student pilot failed to compensate for the crosswind condition and failed to maintain directional control. Factors included the crosswind and the windsock.NTSB ANC05CA062Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's failure to compensate for a crosswind during the landing roll, which resulted in a loss of control and the airplane nosing over. A factor associated with the accident was a crosswind, and an inadvertent ground loop.NTSB LAX05WA150Accident · 1 fatalForeign investigationCessna A150L · Healesville, AustraliaNTSB LAX05LA146Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22A · Kailua-Kona, HIa total loss of engine power due to the failure of the engine's #3 exhaust valve due to an excessive valve guide clearance. Contributing to the accident was the failure of maintenance personnel to adequately check the valve guide clearance during the last…NTSB CHI05CA108Accident · No injuriesData collectionFinal reportInterstate S-1A-90F · Lancaster, KSA loss of engine power due to fuel exhaustion as a result of a fuel leak. Contributing factors were the pilot's inadequate preflight/planning preparation and the unsuitable terrain encountered, the tree and the fence.NTSB NYC05FA075Accident · 2 fatalField investigationFinal reportCessna 172R · Armonk, NYThe flight instructor's failure to maintain the proper altitude\clearance during the approach, which resulted in an in-flight collision with trees. Factors in this accident were low ceilings, fog, and gusty wind conditions.NTSB MIA05LA096Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Deland, FLThe pilot's inadequate visual lookout.NTSB LAX05CA145Accident · No injuriesData collectionFinal reportCessna 180 · Corona, CAthe pilot's inadequate compensation for a crosswind/wind gust condition and his failure to maintain directional control during landing rollout.NTSB IAD05WA065Accident · No injuriesForeign investigationReims F150L · Steinfeld, GermanyNTSB CHI05WA106Accident · Serious injuriesForeign investigationCessna T310R · Barth, GermanyNTSB SEA05LA087Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Roseburg, ORLoss of engine power for undetermined reasons. High vegetation was a factor.NTSB LAX05LA144Accident · Serious injuriesLimited investigationFinal reportBishop RV6A · Dulzura, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with rising mountainous terrain.NTSB DEN05LA070Accident · No injuriesLimited investigationFinal reportRoss/Stonecipher Vans RV-6 · Longmont, COthe loss of engine power due to oil starvation. A contributing factor was the contamination in the inverted oil system's separator.NTSB SEA05MA085Accident · 3 fatalMajor investigationFinal reportLockheed P-3B · Chico, CATerrain clearance was not maintained while maneuvering for undetermined reasons. Mountainous terrain was a factor.NTSB LAX05CA142Accident · No injuriesData collectionFinal reportRankin Quickie Q2 · Chino, CAthe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during landing rollout.NTSB DFW05LA106Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Perry, OKA loss of engine power for undetermined reasons. A contributing factor was collision with a piece of farm equipment.NTSB SEA05LA084Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kalispell, MTAn airborne fire which was fueled by leaking hydraulic fluid (the ignition source for the fire was undetermined) from the landing gear hydraulic system located under the cockpit instrument panel due to inadequate maintenance from other maintenance personnel.…NTSB NYC05LA074Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Southbury, CTThe failure of the counter weight aft snap ring to hold the associated plate and pin in place, which resulted in a total loss of engine power.NTSB MIA05LA095Accident · Serious injuriesLimited investigationFinal reportBell 206B · Coral Springs, FLThe pilot encountered dynamic rollover while lifting off from an area in the everglades with 6-7 foot tall sawgrass nearby.NTSB LAX05LA141Accident · Serious injuriesLimited investigationFinal reportBailey Lowing Loadster · Bakersfield, CAthe loss of engine power for undetermined reasons.NTSB LAX05LA140Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Paso Robles, CAthe separation of the number 4 engine cylinder due to improperly torqued cylinder hold down nuts. A finding in this accident was the lack of a shoulder restraint system in the airplane, which contributed to the occupants' injuries.NTSB IAD05LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Hampton, NHThe pilot's improper decision to depart with a tailwind, and his failure to perform preflight performance calculations.NTSB CHI05LA104Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Downs, KSThe loss of engine power due to the failure of the number two cylinder which was the result of the maintenance facility's failure to detect the fatigue crack in the number two cylinder during the engine overhaul. A factor to the accident was the soft field.NTSB CHI05FA103Accident · 1 fatalField investigationFinal reportCessna 150M · Festus, MOThe pilot's inadequate preflight weather evaluation and his failure to maintain aircraft control during the landing approach. A contributing factor to the accident was the pilot's inadvertent flight in close proximity to a severe thunderstorm associated with…NTSB CHI05CA101Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Gordon, NEThe student pilot's failure to maintain direction control during landing. The pilot lack of familiarity with the airplane was a factor.NTSB SEA05LA077Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Tupelo, MSA loss of engine power due to the inadequate in-flight planning and the pilot's failure to refuel the airplane resulting in fuel exhaustion.NTSB MIA05CA094Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Lakeland, FLThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control during landing resulting in the airplane departing the runway and colliding with a ditch.NTSB DFW05CA107Accident · No injuriesData collectionFinal reportBell P39 · Fredericksburg, TXThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the reported partial failure of the left wheel brake.NTSB CHI05LA099Accident · No injuriesLimited investigationFinal reportCessna 195A · Jackson, MIThe fracture of the left brake master cylinder piston rod, which resulted in the total failure of the left-side brake system and the subsequent loss of directional control during landing roll. An additional cause was the encountered ground-loop.NTSB ANC05CA060Accident · No injuriesData collectionFinal reportCessna A185E · Wasilla, AKThe flight instructor's failure to provide adequate supervision of the second pilot during the landing roll, which resulted in a loss of control and an intentional ground-loop by the instructor. A factor in the accident was the dual student's ( a certificated…NTSB SEA05CA083Accident · No injuriesData collectionFinal reportHughes 269A · Whitefish, MTThe student pilot's failure to maintain control of the helicopter while hovering resulting in an in-flight collision with terrain. Gusting winds and the student pilot's inadequate compensation for the wind conditions were contributing factors.NTSB NYC05CA073Accident · No injuriesData collectionFinal reportCessna 172N · Wellington, OHThe pilot's failure to obtain the proper touchdown point, and his failure to initiate a go-around, which resulted in an overrun during landing. A factor in the accident was the tail wind.NTSB DFW05LA105Accident · No injuriesLimited investigationFinal reportBeech A36 · Early, TXA loss of engine power due to the improper installation of the oil filter resulting in oil starvation and eventual seizure of the engine. A contributing factor was the lack of suitable terrain for the forced landing.