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 FTW95LA379Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Loop, TXThe pilot's failure to maintain clearance with the power line. A factor was the sun glare light conditions.NTSB CHI95LA308Accident · No injuriesLimited investigationFinal reportLet L-23 Super Blanik · White Bear Lake, MNthe pilot's delayed retraction of the spoilers. Factors were the excessive sink rate and the power lines.NTSB CHI95LA306Accident · Serious injuriesLimited investigationFinal reportPiper PA-11 · Badger, SDthe pilot's failure to maintain adequate airspeed while making a steep right turn. A contributing factor was the insufficient altitude needed to make a recovery.NTSB SEA95LA208Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Salem, ORA loss of power for undetermined reasons and the pilot's failure to maintain airspeed while maneuvering for a forced landing.NTSB SEA95LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mt Pleasant, UTThe pilot in command's failure to maintain airspeed during climbout. Factors include wind shear and high density altitude.NTSB SEA95LA204Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Corvallis, ORShearing of the right main landing gear shock strut retainer cap retaining pins.NTSB SEA95FAMS1Accident · 3 fatalMissing aircraftFinal reportPiper PA-28-140 · Missing, WAUndetermined until the Missing aircraft is located.NTSB NYC95LA214Accident · 1 fatalLimited investigationFinal reportGillet C.P. 328 · Fire Island, NYthe failure of the pilots to maintain control of the airplane while performing aerobatics.NTSB LAX95LA325Accident · 1 fatalLimited investigationFinal reportChambers C1C · Turlock, CAa loss of engine power due to fuel system contamination and the pilot's failure to maintain an adequate airspeed while maneuvering for an emergency landing. Factors in the accident were: the inadequate procedures used to purge the fuel system of known…NTSB LAX95LA324Accident · No injuriesLimited investigationFinal reportWelles Kitfox Speedster · San Luis Obispo, CAthe pilot's failure to maintain directional control.NTSB FTW95LA381Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Boulder, COFailure by the pilot to maintain control of the aircraft during landing roll.NTSB SEA95LA205Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Stehekin, WAThe pilot's failure to maintain airspeed after takeoff.NTSB SEA95FA199Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Sheridan, WYfuel starvation for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB SEA95FA198Accident · 1 fatalField investigationFinal reportBeech A24R · Yakima, WAThe pilot's failure to maintain clearance from a tree. Factors related to the accident were: the pilot's poor judgment and ostentatious display to buzz.NTSB NYC95LA216Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Boothbay Harbor, MEthe pilot's misjudgment of distance and altitude, while on final approach to land. Factors relating to the accident were: sunglare, and the pilot's lack of visual cues (visual perception).NTSB NYC95LA213Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Meriden, CTthe pilot's failure to maintain directional control during the landing roll which resulted in the aircraft veering off the runway, and a subsequent collision with a fence.NTSB NYC95FA212Accident · 1 fatalField investigationFinal reportPiper PA-18A-150 · Egg Harbor, NJFailure of the pilot to maintain adequate airspeed during pull-up from a banner pickup, which resulted in a stall and collision with trees before recovering from the stall.NTSB LAX95FA322Accident · 2 fatalField investigationFinal reportFloyd Lancair 200 SE · Georgetown, CAa partial loss of engine power for undetermined reasons, and the pilot's failure to abort the takeoff in a timely manner. The tailwind was a factor.NTSB CHI95LA311Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Staples, MNthe pilot's delay in the application of carburetor heat, which resulted in carburetor ice, loss of engine power, and a subsequent forced landing in a swampy area. The carburetor icing (weather) condition was a related factor.NTSB CHI95LA309Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Walworth, WIloss of engine power which occurred for an undetermined reason. A factor was the soft terrain in the emergency landing site.NTSB CHI95LA304Accident · No injuriesLimited investigationFinal reportKevin Naser Renegade Spirit · Tekamah, NEthe reason for the loss of engine power was undetermined.NTSB CHI95LA302Accident · 1 fatalLimited investigationFinal reportMorrow Starduster I · Ottawa, KSthe pilot's delayed remedial action during the inverted spin maneuver. A factor associated with the accident was the pilot's lack of recent experience in the type operation.NTSB CHI95LA293Accident · Serious injuriesLimited investigationFinal reportPatin Challenger II · Cedar Springs, MIinadequate engine maintenance by the owner/pilot-mechanic. Factors associated with the accident were fouled spark plugs and the pilot not being able to maintain proper altitude/clearance between his airplane and the electrical power lines during his landing…NTSB CHI95FA310Accident · 1 fatalField investigationFinal reportChampion 7GCB · Howard, WIa loss of engine power due to water-contaminated fuel and the pilot's inadequate preflight.NTSB CHI95FA307Accident · 1 fatalField investigationFinal reportCessna 172M · Orr, MNthe pilot misjudged the landing flare. Factors associated with the accident were the visual illusion caused by the glassy smooth water condition and the forward center of gravity.NTSB ANC95LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Igiugig, AKThe pilot's inadequate preflight planning/preparation to assure the airplane would maintain adequate altitude/clearance from the river bank during takeoff.NTSB SEA95LA202Accident · Minor injuriesLimited investigationFinal reportde Havilland DHC-2 · Blakely Island, WAThe pilot's inadequate compensation for wind conditions during takeoff. A factor was the sudden change in wind direction.NTSB NYC95LA217Accident · No injuriesLimited investigationFinal reportCessna 172 · Quakertown, PAthe pilot's failure to maintain directional control, and the pilot's improper use of the wing flaps, which resulted in an inadvertent stall, and contact with trees. A factor was the crosswind.NTSB NYC95LA215Accident · Minor injuriesLimited investigationFinal reportSchleicher KA-8B · Mayville, NYThe pilot's inadequate inflight planning, which resulted in an inflight collision with trees.NTSB LAX95LA327Accident · No injuriesLimited investigationFinal reportCessna 180B · Cooledge, AZthe pilot's inadequate compensation for the crosswind gust.NTSB LAX95LA320Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Santa Rosa, CAthe pilot's failure to maintain directional control. The pilot's improper use of the brakes and the soft terrain were factors in this accident.NTSB LAX95FA321Accident · 2 fatalField investigationFinal reportCessna 421C · Phoenix, AZThe pilot's failure to maintain positive aircraft control, a proper airspeed and fly a proper approach path during final approach. Contributing factors to the accident were the pilot's physiological condition, impairment as a result of using a sedating…NTSB LAX95FA319Accident · 8 fatalField investigationFinal reportCessna 421C · Beaver Dam, AZFailure of the pilot to maintain adequate airspeed, while maneuvering on approach, which resulted in an inadvertent stall/spin and uncontrolled collision with terrain. Factors relating to the accident were: the pilot allowed the aircraft weight and balance…NTSB FTW95LA378Accident · No injuriesLimited investigationFinal reportMaule M5-210C · Westcliffe, COFailure by the pilot to maintain directional control of the aircraft during taxi. A factor was lack of experience in make and model aircraft.NTSB FTW95LA377Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Westcliffe, COFailure by the pilot to maintain directional control. A factor was gusting cross winds.NTSB FTW95LA376Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Colorado Spgs, COAn encounter with a wind shift during landing.NTSB CHI95LA312Accident · No injuriesLimited investigationFinal reportMooney M20C · Ironwood, MIthe pilot's failure to maintain control of the airplane due to his diverted attention.NTSB CHI95FA305Accident · 1 fatalField investigationFinal reportBeech C35 · Omaha, NEthe pilot's failure to maintain airspeed during the takeoff climb. Factors associated with the accident were the pilot's inadequate compensation for the crosswind condition and exceeding the aircraft weight and balance.NTSB CHI95FA301Accident · 1 fatalField investigationFinal reportKiesel Easy Varieze · Dwight, ILinadequate preflight planning by the pilot. A factor associated with this accident was the pilot did not perform an aborted takeoff is sufficient time to safely stop.NTSB BFO95LA092Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Roanoke, VAThe pilot's improper in-flight planning/decision, which resulted a loss of engine power due to fuel exhaustion. Factors relating to the accident were: the pilot's inadequate planning/preparation, her lack of familiarity with the airplane, and soft terrain in…NTSB ANC95LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Big Lake, AKThe pilot's failure to maintain a proper rate of descent during the approach to land, and his misjudgment of altitude to flare for landing on glassy water. The glassy water condition was a related factor.NTSB SEA95LA201Accident · No injuriesLimited investigationFinal reportBristol RV-6 · Grants Pass, ORa loss of engine power for undetermined reasons.NTSB NYC95LA211Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Seaside Heights, NJThe pilot's inadequate flare for landing, which resulted in an in-flight collision with rough water. Factors relating to the accident were: loss of engine power for an undetermined reason and rough water.NTSB NYC95FA210Accident · 3 fatalField investigationFinal reportCessna 172M · Portland, MEan engine malfunction for an undetermined reason, and the pilot's failure to maintain airspeed during a forced landing which resulted in an accelerated stall. A factor was the pilot's lack of recent experience.NTSB MIA95WA242Incident · No injuriesForeign investigationAero Commander 500 · Nassau, BahamasNTSB LAX95LA318Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Dos Palos, CAthe fatigue failure of the tail rotor tension torsion bar plates.NTSB FTW95LA375Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bonham, TXThe partial loss of engine power for undetermined reasons. Factors were the high density altitude and lack of suitable terrain for the forced landing.NTSB FTW95LA374Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Colorado Spgs, COBlockage of the carburetor by a piece of foreign material, which resulted in a loss of engine power, and failure of the pilot to maintain airspeed, which resulted in an inadvertent stall. The high density altitude and the pilot's failure to properly lean the…NTSB CHI95LA303Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Saint James, MIthe pilot's operation of the airplane with an inoperative fuel gage and the leaking fuel line fitting, which resulted in fuel exhaustion, loss of engine power, and a forced landing. The inoperative fuel gage was a related factor.NTSB ANC95LA158Accident · 1 fatalLimited investigationFinal reportShort Brothers SC-7 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions. The weather was a factor.