NTSB investigations, 1995
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WHERE year(c.\"eventDate\") = 1995 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 WHERE year(c."eventDate") = 1995 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 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.NTSB FTW95LA373Accident · No injuriesLimited investigationFinal reportPiper PA-60-601P · Broomfield, COThe pilot's attempt to taxi with a known inoperative brake. A factor was partial brake failure due to a leaking seal.NTSB SEA95LA200Accident · No injuriesLimited investigationFinal reportCessna 210 · Sunriver, ORThe failure of the landing gear hydraulic drive motor.NTSB SEA95LA197Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Spokane, WAthe pilot's failure to maintain airspeed while trying to clear a transmission wire. Factors include a transmission wire near the end of the takeoff area and glassy water.NTSB NYC95LA208Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Andover, NJThe flight instructor's inadequate preflight which failed to detect an inadequate fuel supply which subsequently resulted in fuel exhaustion and the loss of engine power.NTSB LAX95LA317Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yuma, AZthe flight instructor's inadequate supervision of the flight and the failure of both pilots to maintain directional control.NTSB LAX95LA316Accident · No injuriesLimited investigationFinal reportCessna 172A · Weed, CAthe flight instructor's failure to maintain directional control of the aircraft.NTSB LAX95LA314Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Marana, AZthe pilot's poor installation of the propeller which allowed the propeller to become loose, and the pilot's improper emergency procedure by feathering the wrong propeller.NTSB LAX95FA313Accident · 2 fatalField investigationFinal reportBell 206-L1 · Johnsondale, CAthe pilot's failure to maintain an adequate obstacle clearance altitude while operating at a very low level. The aircraft's lack of wire cutters was a factor in this accident.NTSB BFO95LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Martinsburg, WVthe student pilot's failure to maintain control of the airplane during the landing/aborted landing sequence. A related factor is the student pilot's lack of total flight experience.NTSB SEA95LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Arock, ORThe pilot's failure to maintain directional control during takeoff from a dirt road.NTSB LAX95LA312Accident · No injuriesLimited investigationFinal reportRobinson R-22 · El Monte, CAthe student's improper use of the cyclic control; the flight instructor's inadequate supervision of the flight; and the flight instructor's failure to maintain an adequate obstacle clearance distance in selection of a practice slope landing area.NTSB LAX95LA309Accident · No injuriesLimited investigationFinal reportJosephson MC-15 Cricket · San Diego, CAthe failure of the left engine due to inadequate maintenance of the ignition system.