NTSB investigations, 1995
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 CHI96LA011Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-31 · Cedar Rapids, IAinadequate installation of a thrust reverser, driver linkage arm pivot bolt and nut, which resulted in the nut and bolt becoming disconnected. A factor relating to the accident was: the manufacturer's unclear information regarding the type and number of…NTSB BFO96IA012Incident · No injuriesIncident investigationFinal reportPiper PA-23 · Beckley, WVan in-flight fire (behind the right side of the instrument panel), which occurred for undetermined reason(s).NTSB NYC96LA007Accident · No injuriesLimited investigationFinal reportTeague Pitts S-1S · Erwinna, PAthe pilot's misjudged flare and improper bounced landing recovery. Factors were the pilot's lack of recent experience and a false oil pressure gauge indication.NTSB MIA96LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Covington, GAthe pilot's failure to divert to an alternate airport after recognizing a low fuel state existed and his delay to declare an emergency with ATC. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB ATL96LA005Accident · No injuriesLimited investigationFinal reportMooney M20K · Dalton, GAOil starvation for an unknown reason, which resulted in progressive connecting rod failure and subsequent loss of engine power. Factors relating to the accident were: the unfavoable weather and light conditions (low ceiling and fog at dusk), which hampered…NTSB ATL96LA004Accident · 1 fatalLimited investigationFinal reportLopez Lancair 360 · Atlanta, GAthe noninstrument-rated pilot's intentional VFR flight into instrument meteorological conditions which led to a loss of control.NTSB LAX96LA009Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Hana, HIthe loss of engine power due to inadequate maintenance inspection of the fuel system which permitted air to enter the engine fuel supply. A factor in the accident was the pilot's improper execution of the autorotation landing.NTSB FTW96LA016Accident · No injuriesLimited investigationFinal reportCessna 182E · Fort Collins, COa fatigue failure of the right main landing gear. Factors were the pilot's failure to attain the proper touchdown point and his inadequate compensation for the crosswind conditions.NTSB BFO96LA009Accident · No injuriesLimited investigationFinal reportAerostar Raven S49A · Ark, VAthe flight instructor's improper procedures while inflating the balloon using an external fuel source, and the fuel leak.NTSB BFO96LA008Accident · No injuriesLimited investigationFinal reportGrumman American G-1159 · Cleveland, OHthe pilots' failure to attain the proper touchdown point and avoid obstacles (construction barricades) during the landing flare/touchdown. Related factors were: the sunglare, which limited in the pilots' visual lookout during the approach, and the unavailable…NTSB BFO96FA007Accident · 2 fatalField investigationFinal reportCessna 172M · Norwich, VTloss of engine power for undetermined reason(s), during a low altitude operation. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW96LA015Accident · Minor injuriesLimited investigationFinal reportAdams Kitfox · Seminole, TXthe pilot's excessive braking.NTSB CHI96LA007Accident · Minor injuriesLimited investigationFinal reportRoisum Team MINI-MAX · Neenah, WIFuel starvation due to fuel filter blockage. Factors associated with the accident were the manufacturers design of the fuel filter and the builder/pilots decision to use an automotive type fuel filter.NTSB CHI96LA006Accident · No injuriesLimited investigationFinal reportCessna 172F · Danbury, WIthe partial failure of the left magneto, the road sign, and the road embankment. A factor relating to this accident is the brush which obscured the road sign.NTSB NYC96LA006Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Honeoye Falls, NYthe pilot's failure to establish a climb in that he failed to raise the flaps and failed to assure full power was applied during the go-around.NTSB MIA96LA005Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Opa Locka, FLThe pilot's failure to maintain directional control of the airplane on landing resulted in a loss of control, sliding off the runway into a rock collapsing the landing gear.NTSB FTW96LA013Accident · Serious injuriesLimited investigationFinal reportAerostar RX 8 · Albuquerque, NMThe pilot's improper in-flight planning/decision. The variable wind condition was a related factor.NTSB FTW96FA012Accident · 3 fatalField investigationFinal reportCessna 172RG · Bayfield, COThe pilot's failure to maintain adequate terrain clearance. A factor was the pilot diverting attention while looking for game.NTSB BFO96LA005Accident · 1 fatalLimited investigationFinal reportTravel Air R · Youngstown, OHthe pilot's improper flare during the landing, which resulted in a hard landing, fuselage damage, loss of aircraft control, and a nose over. A factor relating to the accident was: the pilot's lack of experience in the make and model of airplane.NTSB NYC96LA005Accident · No injuriesLimited investigationFinal reportKelosky Pulsar XP · Zelienople, PAThe pilot inadvertently allowed the airplane to lift-off during a high speed taxi check, while operating the airplane with a known deficiency that consisted of a partially blocked quick disconnect fitting, which resulted in fuel starvation and the loss of…NTSB LAX96LA006Accident · No injuriesLimited investigationFinal reportCessna 172N · Tucson, AZthe pilot's inadequate compensation for the existing tailwind conditions, improper flare, and failure to maintain directional control.NTSB LAX96LA005Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Tucson, AZfuel starvation due to swelling of the carburetor needle valve tip, which restricted the fuel flow to the carburetor inlet. A factor in the accident was the use of automotive gasoline.NTSB FTW96LA014Accident · No injuriesLimited investigationFinal reportCessna 172M · Sugar Land, TXthe student pilot's diverted attention and failure to maintain directional control.NTSB CHI96LA004Accident · No injuriesLimited investigationFinal reportCessna 152II · Troy, MIthe pilot's inadequate recovery from a bounced landing. A factor associated with the accident was the quartering tailwind condition and the pilot's selection of the wrong runway on which to land.NTSB CHI96LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Thorp, WIthe pilot's failure to abort the takeoff and the premature liftoff which resulted in an inadvertent stall. Factors relating to this accident are improper planning and decision by the pilot, and the tall, wet grass.NTSB SEA96LA005Accident · 1 fatalLimited investigationFinal reportChard RV-3A · Forest Grove, ORThe pilot exceeded the design stress limit of the aircraft, followed by the failure of the right wing main spar.NTSB FTW96LA010Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Crockett, TXfailure of both magnetos to operate properly due to inadequate maintenance by other maintenance personnel. A factor was the lack of suitable terrain available for the forced landing.NTSB CHI96FA005Accident · 1 fatalField investigationFinal reportBlatter-Pitts S2S · Waukegan, ILthe pilot's failure to maintain airplane control during the aerobatic maneuver. Factors associated with the accident were: an improper weight and balance with a center of gravity aft of the rear limit, the pilot's overconfidence in his personal ability, and…NTSB BFO96FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bird-In-Hand, PAthe pilot's (PIC's) improper in-flight planning/decision concerning simulated instrument flight during the traffic pattern/descent; and failure of the safety pilot (other crewmember) to provide adequate visual lookout to see-and-avoid the obstruction.NTSB SEA96LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control. A factor to the accident was inadequate remedial action.NTSB SEA96LA004Accident · No injuriesLimited investigationFinal reportVans RV-6T · North Plains, ORFuel starvation due to the failure of the left tank fuel quantity sending unit which resulted in a false indication of fuel quantity. A factor was the lack of suitable terrain for the forced landing.NTSB NYC96FA004Accident · 1 fatalField investigationFinal reportCessna P206A · Fishkill, NYThe pilot's VFR flight into instrument meteorological conditions. Contributing factors were the fog and dusk light conditions.NTSB MIA96LA004Accident · 1 fatalLimited investigationFinal reportLouks Pulsar XP · Inverness, FLPremature rotation by the pilot during takeoff, which resulted in an inadvertent stall/mush, while attempting to accelerate in ground effect after lift-off.NTSB LAX96FA004Accident · 3 fatalField investigationFinal reportBeech A-36 · Beaver Dam, AZThe pilot's improper use of the fuel selector valve, which resulted in fuel starvation; and her failure to maintain adequate airspeed while maneuvering, which resulted in an inadvertent stall.NTSB FTW96LA011Accident · No injuriesLimited investigationFinal reportCessna 195A · Taos, NMseparation of the left main gear wheel as a result of improper maintenance.NTSB FTW96FA009Accident · 1 fatalField investigationFinal reportRupe RV-4 · Longmont, COthe installation of an unapproved metal propeller which led to a fatigue failure of a blade and loss of aircraft control.NTSB BFO96LA006Accident · Minor injuriesLimited investigationFinal reportMadsen/Rans Rans S12 Airaile · Cobbs Creek, VAloss of engine power for undetermined reasons.NTSB ANC96LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKImproper planning/decision by the pilot concerning his method of testing the landing area. His selection of an unsuitable area was a related factor.NTSB ANC96LA003Accident · No injuriesLimited investigationFinal reportCessna 180K · Cold Bay, AKthe pilot's selection of an unsuitable area/terrain for landing. The submerged sandbar was a related factor.NTSB SEA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Mulino, ORthe failure of the pilots to use carburetor heat during a reduced power descent. A factor was the carburetor icing conditions.NTSB NYC96FA003Accident · 2 fatalField investigationFinal reportEnstrom 280C · Quakertown, PAimproper installation of the magneto by maintenance personnel, which resulted in the loss of ignition and the loss of engine power. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB MIA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Spring Hill, FLThe pilot's failure to maintain airspeed (VMC) on initial takeoff climb resulting in an in-flight loss of control, and subsequent in-flight collision with the ground and a building. Contributing to the accident was a partial loss of engine power on the left…NTSB LAX96LA007Accident · No injuriesLimited investigationFinal reportSchlitter Rans S-9 · Chandler, AZseizure of the #2 cylinder for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB CHI96FA002Accident · 2 fatalField investigationFinal reportBeech H35 · Ozark, MOthe pilot's improper fuel management which resulted in fuel starvation, and his failure to maintain airspeed during the forced landing.NTSB BFO96LA003Accident · No injuriesLimited investigationFinal reportEnstrom F28-280C · Blue Ash, OHthe commercial pilot's failure to maintain clearance from obstacles during hover-taxi operations. Related factors the tailwind, the nearby obstacle, and the misjudged maneuver to avoid obstacles.NTSB ATL96LA003Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Shores, ALLoss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.NTSB ANC96LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Healy, AKA failure of the pilot to adequately compensate for crosswind conditions. A factor in the accident was a crosswind.NTSB ANC96LA001Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Hoonah, AKthe pilot's inadequate preflight planning/preparation. Factors relating to the accident were: improper weight and balance configuration, and unsuitable terrain in the emergency landing area.NTSB FTW96LA008Accident · Minor injuriesLimited investigationFinal reportBell 47-G2 · Freer, TXthe pilot's failure to maintain clearance from the power lines due to his improper takeoff technique. A factor was the helicopter induced blowing dust which impaired the pilot's visibility.NTSB FTW96LA007Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Hamburg, ARLoss of engine power due to a cylinder failure. A factor relating to the accident was: the lack of suitable terrain for the forced landing.