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 MIA95IA238Incident · Minor injuriesIncident investigationFinal reportBoeing 737-400 · Fort Lauderdale, FLInadequate written maintenance procedures addressing steps to be followed in the event of a component failure during an engine wash. The emergency slides failed to deploy due to improper installation by company maintenance personnel.NTSB FTW95LA404Accident · 1 fatalLimited investigationFinal reportFratus XP-23 Hawk · Joshua, TXthe pilot's failure to see and avoid the wires.NTSB CHI95LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Poseyville, INthe pilot's poor judgement in making a night takeoff on an unlit runway and his failure to maintain proper runway alignment. Factors associated with the accident were the hay bale, the night conditions and the unlit runway.NTSB SEA95LA226Accident · No injuriesLimited investigationFinal reportCessna 340 · Riverton, WYa partial loss of hydraulic fluid in the left brake system rendering the left brake inoperative.NTSB MIA95LA237Accident · 1 fatalLimited investigationFinal reportAerotek Pitts - S2S · Clarksville, VAcontinued flight by the pilot into instrument meteorological conditions (IMC), which resulted in spatial disorientation and his inability to control the airplane. The weather condition and the lack of instruments in the airplane were related factors.NTSB FTW95FA402Accident · 5 fatalField investigationFinal reportPiper PA-24B-260 · Westcliffe, COVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors relating to the accident were: the light conditions at dusk, the adverse weather…NTSB FTW95FA401Accident · 1 fatalField investigationFinal reportCessna T210L · Groom, TXLoss of control for unknown reason(s).NTSB CHI95LA333Accident · Minor injuriesLimited investigationFinal reportFairchild FA-24 · Blountsville, INpartial loss of engine power for an undetermined reason, and the pilot's improper in-flight planing/decision. Factors relating to the accident were: the pilot's misuse of flaps, and his encounter with high obstruction during the forced landing.NTSB CHI95LA332Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ludington, MIfuel exhaustion resulting from the pilot's inaccurate fuel calculations and the failure to refuel the airplane prior to takeoff. An additional cause was the stall/mush during the forced landing.NTSB ATL95LA170Accident · No injuriesLimited investigationFinal reportBeech A35 · Knoxville, TNThe pilot's failure to use the carburetor heat during the approach. The factors were: failure to obtain a weather briefing, and weather conditions favorable for the formation of carburetor icing.NTSB NYC95LA232Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Warwick, NYThe student pilot's misjudgement of distance and speed, and his failure to perform a go-around while there was still sufficient runway remaining.NTSB NYC95LA225Accident · 2 fatalLimited investigationFinal reportSnyded Pitts S1E · Somers, NYThe pilot's inadequate visual lookout, which resulted his failure to see-and-avoid the power line.NTSB NYC95FA224Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Marlborough, MAthe Stearman, N89X, pilot's inadequate visual lookout. A factor was the failure of the flight instructor of the Cessna 150, N1766Q, to announce his position in the traffic pattern in accordance with recommended procedures.NTSB MIA95LA234Accident · No injuriesLimited investigationFinal reportCessna 150 · Sarasota, FLThe failure of the pilot to perform fuel consumption calculations resulting in a loss of power due to fuel exhaustion.NTSB FTW95LA405Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Como, COThe pilot allowing the glider to develop an excessive descent rate. A factor was the premature and automatic disengagement of the winch-tow system.NTSB FTW95LA403Accident · No injuriesLimited investigationFinal reportCessna 195 · Moriarty, NMthe pilot's inadequate compensation for the winds. A factor was the crosswind.NTSB CHI95LA340Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235B · Highland, ILa communication misunderstanding between the tow pilot and the glider pilot. Factors related to the accident were: the tow rope becoming entangled, excessive taxispeed by the tow pilot, and the unavailability of a dispatcher.NTSB BFO95FA097Accident · 1 fatalField investigationFinal reportBeech F33A · Farmingdale, NYfailure of the pilot to maintain pitch control of the airplane during the initial climb after lift-off, which resulted in a steep climb, loss of airspeed, and a resultant stall/spin and subsequent crash. A factor relating to the accident was: failure of the…NTSB ATL95FA173Accident · 2 fatalField investigationFinal reportCessna 310P · Lexington, MSthe non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions and his failure to maintain control of the aircraft. The weather was a factor.NTSB SEA95LA224Accident · 1 fatalLimited investigationFinal reportMacphee Vans RV-6 · Jacksonville, ORthe pilot-in-command's failure to maintain altitude and/or clearance from surrounding terrain after a low pass. The mountainous terrain was a factor.NTSB SEA95LA223Accident · 2 fatalLimited investigationFinal reportEurocopter AS350BA · Crater Lake, ORFailure of the pilot to maintain sufficient altitude/clearance above water, while performing low altitude flight. Factors relating to the accident were: the glassy water condition, and lack of visual cues concerning perception of altitude.NTSB NYC95LA226Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Auburn, NYthe loss of airplane control as a result of a jammed rudder for undetermined reasons.NTSB MIA95LA233Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Dyer, TNThe pilot-in-command's failure to properly manage the fuel required for the flight, resulting in a total loss of engine power due to fuel exhaustion and subsequent in flight collision with trees and terrain.NTSB MIA95LA231Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Augustine, FLFuel starvation for undetermined reasons resulting in the total loss of engine power. Contributing to the accident was unsuitable terrain encountered during the forced landing.NTSB LAX95LA343Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Kona, HIthe failure of the student pilot to properly execute a planned steep approach and long landing so as to avoid wake turbulence behind the preceding large aircraft.NTSB CHI95LA330Accident · No injuriesLimited investigationFinal reportHard Maxair Drifter · Mexico, MOfuel exhaustion as a result of excessive fuel flow, and failure of the pilot not properly monitoring fuel consumption. Rough/uneven terrain in the emergency landing area was a related factor.NTSB ANC95LA176Accident · No injuriesLimited investigationFinal reportCessna 180 · Craig, AKThe pilot's selection of an unsuitable taxi/takeoff area.NTSB ANC95LA175Accident · No injuriesLimited investigationFinal reportCessna 150 · Coldfoot, AKThe pilot's failure to maintain control of the airplane, while landing.NTSB MIA95TA230Accident · Serious injuriesFinal reportBell 206B · Culebra, PRthe failure of company maintenance personnel to insure the tail rotor gearbox attach bolts were properly torqued.NTSB CHI95LA329Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Hudson, WIthe pilot's improper decision to attempt a touch-and-go on a short airstrip.NTSB BFO95LA098Accident · No injuriesLimited investigationFinal reportCessna 182 · Annapolis, MDThe pilot's failure to maintain control of the airplane during the landing roll. Related factors were the sudden thunderstorm, the high gusty winds, and the sudden windshift to a tailwind during the touchdown/landing roll.NTSB ATL95LA172Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lynchburg, SCThe failure of the magneto mount pad, which resulted in a malfunction of the magneto timing and partial loss of engine power. A factor relating to the accident was: high vegetation in the emergency landing area.NTSB ANC95IA173Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Gustavus, AKfatigue failure of the propeller blade due to previous foreign object damage.NTSB SEA95LA222Accident · No injuriesLimited investigationFinal reportCessna 150M · College Place, WAthe pilot-in-command's inaccurate fuel consumption calculations which led to fuel exhaustion.NTSB MIA95LA229Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502 · Lorida, FLMismanagement of the fuel by the pilot resulting in the total loss of engine power due to fuel exhaustion, and the pilot's poor decision to fly over water en route to the refueling airport.NTSB MIA95LA227Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · Vero Beach, FLFailure of company maintenance personnel to comply with a required airworthiness directive, resulting in an in-flight fire and emergency landing. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB MIA95FA226Accident · Serious injuriesField investigationFinal reportMitsubishi MU-2B-35 · Smyrna, TNFailure of the pilot to maintain a proper climb rate after takeoff, and his inadvertent entry in a descending spiral, which he failed to correct. Factors relating to the accident were: darkness, and the pilot becoming spatially disoriented during the initial…NTSB LAX95LA348Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Marana, AZthe pilot misjudged clearance from the power lines.NTSB FTW95FA399Accident · 1 fatalField investigationFinal reportAir Tractor AT-502A · Coleman, TXthe pilot's continued flight into adverse weather resulting in spatial disorientation and loss of control. A factor was the pilot's improper weather evaluation and the weather.NTSB CHI95FA328Accident · 1 fatalField investigationFinal reportCessna 421B · Coldwater, MIfailure of the pilot to maintain adequate airspeed, while maneuvering (turning) at low altitude, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the adverse weather conditions, and the lack of…NTSB ATL95LA171Accident · No injuriesLimited investigationFinal reportBell 47G · Union City, TNFailure of a #4 connecting rod bolt, which resulted in engine stoppage and a forced landing.NTSB ANC95LA172Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Aniak, AKThe pilot's inadequate weather evaluation. Factors associated with the accident were: the box canyon, rising terrain, wind gusts, and downdrafts.NTSB SEA95LA227Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E · Yakima, WAFatigue failure of the bolt attaching the scissor arm assembly to the pitch control support assembly. The failure of the bolt led to a loss of collective pitch control and reduced rotor RPM.NTSB MIA95WA228Accident · No injuriesForeign investigationCessna A188B · Port Of Spain, Trinidad & TobagoNTSB LAX95FA339Accident · 1 fatalField investigationFinal reportBell 206L-1 · Irvine, CAthe pilot's intentional VFR flight into IMC conditions and failure to maintain an adequate terrain clearance altitude, and the local controller's improper use of ATC procedure/technique. Factors in the accident were the helicopter's low fuel state and lack of…NTSB CHI95LA327Accident · Minor injuriesLimited investigationFinal reportBell 206L · Ware, ILthe pilot's failure to maintain control of the helicopter. A factor in the accident was the pilot's inadvertent VFR flight into IMC conditions.NTSB BFO95LA096Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Medina, OHthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. High vegetation (tall corn) in the emergency landing area was a related factor.NTSB SEA95LA221Accident · Serious injuriesLimited investigationFinal reportBell UH-1L · Grace, IDthe fatigue failure of the centrifugal impeller and the lack of suitable terrain for a forced landing. Factors contributing to the accident were: the lack of required compliance with the FAA Airworthiness Directive by the operator, the insufficiently defined…NTSB NYC95LA223Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Auburn, MAThe loss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a related factor.NTSB LAX95FA338Accident · Minor injuriesField investigationFinal reportSwearingen SA-226T · Chino, CAThe pilot's improper IFR procedure by not initiating a missed approach at the outer marker, by attempting to intercept the glideslope from above after passing the outer marker, and by allowing the airplane to continue descending after reaching the decision…