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.

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.Sep 5, 1995 · N4998X · Substantial damageNTSB 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.Sep 5, 1995 · N99970 · Substantial damageNTSB 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.Sep 5, 1995 · N70613 · DestroyedNTSB 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.Sep 4, 1995 · N9222H · Substantial damageNTSB 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.Sep 4, 1995 · N8261N · Substantial damageNTSB SEA95LA204Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Corvallis, ORShearing of the right main landing gear shock strut retainer cap retaining pins.Sep 4, 1995 · N8865K · Substantial damageNTSB SEA95FAMS1Accident · 3 fatalMissing aircraftFinal reportPiper PA-28-140 · Missing, WAUndetermined until the Missing aircraft is located.Sep 4, 1995 · N571PA · DestroyedNTSB NYC95LA214Accident · 1 fatalLimited investigationFinal reportGillet C.P. 328 · Fire Island, NYthe failure of the pilots to maintain control of the airplane while performing aerobatics.Sep 4, 1995 · N4171G · DestroyedNTSB 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…Sep 4, 1995 · N177GE · DestroyedNTSB LAX95LA324Accident · No injuriesLimited investigationFinal reportWelles Kitfox Speedster · San Luis Obispo, CAthe pilot's failure to maintain directional control.Sep 4, 1995 · N912JW · Substantial damageNTSB FTW95LA381Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Boulder, COFailure by the pilot to maintain control of the aircraft during landing roll.Sep 4, 1995 · N5761G · Substantial damageNTSB SEA95LA205Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Stehekin, WAThe pilot's failure to maintain airspeed after takeoff.Sep 3, 1995 · N4016J · Substantial damageNTSB 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.Sep 3, 1995 · N700TD · Substantial damageNTSB 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.Sep 3, 1995 · N9726Q · DestroyedNTSB 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).Sep 3, 1995 · N98503 · Substantial damageNTSB 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.Sep 3, 1995 · N4671V · Substantial damageNTSB 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.Sep 3, 1995 · N9374D · DestroyedNTSB 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.Sep 3, 1995 · N92RF · DestroyedNTSB 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.Sep 3, 1995 · N9425B · Substantial damageNTSB 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.Sep 3, 1995 · N5465B · Substantial damageNTSB CHI95LA304Accident · No injuriesLimited investigationFinal reportKevin Naser Renegade Spirit · Tekamah, NEthe reason for the loss of engine power was undetermined.Sep 3, 1995 · N494KN · Substantial damageNTSB 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.Sep 3, 1995 · N46565 · DestroyedNTSB 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…Sep 3, 1995 · N4281D · Substantial damageNTSB CHI95FA310Accident · 1 fatalField investigationFinal reportChampion 7GCB · Howard, WIa loss of engine power due to water-contaminated fuel and the pilot's inadequate preflight.Sep 3, 1995 · N9838Y · DestroyedNTSB 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.Sep 3, 1995 · N828MB · DestroyedNTSB 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.Sep 3, 1995 · N5293D · Substantial damageNTSB 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.Sep 2, 1995 · N62SJ · Substantial damageNTSB 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.Sep 2, 1995 · N7154T · Substantial damageNTSB NYC95LA215Accident · Minor injuriesLimited investigationFinal reportSchleicher KA-8B · Mayville, NYThe pilot's inadequate inflight planning, which resulted in an inflight collision with trees.Sep 2, 1995 · N1196 · Substantial damageNTSB LAX95LA327Accident · No injuriesLimited investigationFinal reportCessna 180B · Cooledge, AZthe pilot's inadequate compensation for the crosswind gust.Sep 2, 1995 · N5059E · Substantial damageNTSB 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.Sep 2, 1995 · N31266 · Substantial damageNTSB 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…Sep 2, 1995 · N3911C · DestroyedNTSB 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…Sep 2, 1995 · N6234G · DestroyedNTSB 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.Sep 2, 1995 · N51566 · Substantial damageNTSB FTW95LA377Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Westcliffe, COFailure by the pilot to maintain directional control. A factor was gusting cross winds.Sep 2, 1995 · N4253Z · Substantial damageNTSB FTW95LA376Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Colorado Spgs, COAn encounter with a wind shift during landing.Sep 2, 1995 · N90555 · No damageNTSB CHI95LA312Accident · No injuriesLimited investigationFinal reportMooney M20C · Ironwood, MIthe pilot's failure to maintain control of the airplane due to his diverted attention.Sep 2, 1995 · N7171U · Substantial damageNTSB 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.Sep 2, 1995 · N5999C · DestroyedNTSB 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.Sep 2, 1995 · N17BK · DestroyedNTSB 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…Sep 2, 1995 · N211SP · DestroyedNTSB 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.Sep 2, 1995 · N9033L · Substantial damageNTSB SEA95LA201Accident · No injuriesLimited investigationFinal reportBristol RV-6 · Grants Pass, ORa loss of engine power for undetermined reasons.Sep 1, 1995 · N694CA · Substantial damageNTSB 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.Sep 1, 1995 · N5TB · Substantial damageNTSB 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.Sep 1, 1995 · N6564H · DestroyedNTSB MIA95WA242Incident · No injuriesForeign investigationAero Commander 500 · Nassau, BahamasSep 1, 1995 · C6BFR · No damageNTSB LAX95LA318Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Dos Palos, CAthe fatigue failure of the tail rotor tension torsion bar plates.Sep 1, 1995 · N4027D · Substantial damageNTSB 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.Sep 1, 1995 · N5798J · Substantial damageNTSB 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…Sep 1, 1995 · N4814F · DestroyedNTSB 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.Sep 1, 1995 · N9528L · DestroyedNTSB ANC95LA158Accident · 1 fatalLimited investigationFinal reportShort Brothers SC-7 · Skwentna, AKThe pilot's continued VFR flight into instrument meteorological conditions. The weather was a factor.Sep 1, 1995 · N30GA · Destroyed