NTSB investigations, 1998
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1998 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") = 1998 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 MIA99LA049Accident · No injuriesLimited investigationFinal reportCessna 170 · Lawrenceville, GAThe pilot's failure to maintain directional control.NTSB LAX99LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Big Bear, CAThe pilot's misjudged landing flare, which lead to an inadvertent stall/mush 10 feet above the ground.NTSB LAX99FA052Accident · 1 fatalField investigationFinal reportParkman VARI-EZE · Tucson, AZThe pilot's failure to attain and maintain an adequate flying airspeed during the aircraft's maiden flight, which resulted in a stall/mush condition. Also causal was the pilot/builder's decision to modify the engine and the fuel system control microchip,…NTSB ANC99LA017Accident · No injuriesLimited investigationFinal reportCasa C-212 · Mcgrath, AKThe flightcrew's inadequate compensation for wind conditions. A factor associated with the accident was a crosswind.NTSB SEA99LA022Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Wenatchee, WAFuel exhaustion due to the pilot's failure to accomplish refueling.NTSB LAX99LA056Accident · Serious injuriesLimited investigationFinal reportWeber CA-65 · Red Bluff, CAThe failure of the pilot to remove the right seat belt from around the right control stick, which resulted in a loss of aircraft control. An additional cause is the pilot's failure to use a checklist.NTSB LAX99FA051Accident · No injuriesField investigationFinal reportLearjet 55B · Los Angeles, CAthe total loss of electrical power due to the flight crew's failure to complete the engine start checklist, or the electrical power failure checklist, which kept the generators off line and resulted in the complete discharged of both batteries. Also causal to…NTSB DCA99WA025Accident · 2 fatalForeign investigationBeech 95 · Camarines Provi, PhilippinesNTSB DCA99WA024Accident · 5 fatalForeign investigationBeech 200 · Libreville, GabonNTSB CHI99LA055Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Traverse City, MIThe crew's failure to execute a missed approach and the flying pilot's (captain) failure to maintain directional control upon touchdown with a seven degree left bank and a right quartering tailwind. Factor's were the snow covered runway/landing area and the…NTSB CHI99FA052Accident · 1 fatalField investigationFinal reportCessna 152 · Sherrill, IAthe pilot continued flying with a known discrepancy and he failed to maintain airspeed and lost control of the airplane while attempting a forced landing. Factors included the tailwind and the undetermined loss of power.NTSB ANC99LA016Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Manokotak, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were dark night conditions, snow covered terrain, and low ceilings.NTSB SEA99LA021Accident · No injuriesLimited investigationFinal reportElliott RAF 2000 · Walla Walla, WAThe pilot's failure to maintain directional control after landing.NTSB MIA99RA048Accident · 2 fatalForeign investigationPiper PA-31-310 · Las Mesitas, HondurasNTSB FTW99LA053Accident · Serious injuriesLimited investigationFinal reportDennis Pointer KR-2 · Denton, TXThe pilot's loss of control as result of his improper recovery from a bounced landing.NTSB FTW99LA052Accident · No injuriesLimited investigationFinal reportCessna 182 · Umpire, ARCatastrophic engine failure due to failures of the #5 piston, #5 connecting rod, and the camshaft. A factor was the lack of suitable terrain for a forced landing.NTSB ATL99LA035Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Hanceville, ALThe loss of engine power for undetermined reasons. Factors were a dark night and terrain condition.NTSB MIA99IA046Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Orlando, FLA discharged battery due to a loss of electrolyte, and the latent shorted failures of the No. 1 and 2 generator control unit (GCU) blocking diodes (CR910) for undetermined reasons. These failures resulted in an excessive current drawn from both GCUs, during…NTSB FTW99LA051Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Waxahachie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA050Accident · No injuriesLimited investigationFinal reportBeech BE-95-A55 · Mesquite, TXThe student pilot's failure to maintain directional control during a simulated engine failure during takeoff maneuver and the instructor's inadequate supervision. Factors were; the student's lack of total flight time in multiengine airplanes, and the soft…NTSB FTW99FA049Accident · 2 fatalField investigationFinal reportCessna 150H · Marksville, LAThe pilot's failure to visually identify the hazardous condition of the runway. Factors were the dusk light condition and the pilot's failure to obtain NOTAMs.NTSB DEN99LA026Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Granby, COThe in-flight encounter with clear air turbulence during descent.NTSB SEA99LA020Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1H · Darrington, WAThe total separation of the vertical fin (stabilizer), as the result of fatigue cracks which initiated in the fourth rivet hole above where the fin extends from the tailboom.NTSB LAX99LA050Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Sacramento, CAThe failure of the second and third flight attendants to comply with instructions to remain seated in anticipation of turbulence.NTSB IAD99LA024Accident · Serious injuriesLimited investigationFinal reportBell 47-G5 · Essex Junction, VTthe pilot's improper entry into the autorotation, which resulted in the loss of power and a low rotor rpm condition. Also causal was the pilot's improper execution of the autorotation which resulted in the hard landing. Factors in the accident were the…NTSB FTW99LA047Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Lufkin, TXThe inadvertent stall due to the pilot's improper recovery from a bounced landing.NTSB ATL99LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNWater contamination of the fuel supply, resulting from the pilot's inadequate preflight inspection.NTSB MIA99LA044Accident · Serious injuriesLimited investigationFinal reportRockwell 114A · New Smyrna Bch, FLThe pilots failure to maintain adequate altitude clearance with the terrain during final approach, and the subsequent collision with high vegetation and a road sign.NTSB FTW99LA048Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-BA · San Angelo, TXthe rollover during take off for undetermined reasons.NTSB DEN99LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Glenwood Spring, COThe pilot's failure to maintain directional control. A contributing factor is his inadequate recovery from a bounced landing.NTSB NYC99WA080Accident · Minor injuriesForeign investigationPiper PA-31-350 · Accra, GhanaNTSB NYC99FA037Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Greenville, PAThe pilot's failure to maintain directional control during touch-and-go landing, and his failure to maintain obstacle clearance. A factor was the tree.NTSB LAX99LA047Accident · No injuriesLimited investigationFinal reportBell 47G2 · Helendale, CAThe pilot's failure to follow proper procedures to recover from main rotor blade aerodynamic retreating blade stall.NTSB DCA99WA021Accident · 2 fatalForeign investigationAirbus Industrie 300-200 · Surat Thani, ThailandNTSB MIA99LA062Accident · No injuriesLimited investigationFinal reportBeech C-45G · Charlotte AmaliThe inadequate flare by the pilot-in-command resulting in a hard landing on the nose landing gear causing it to collapse.NTSB LAX99LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Tucson, AZFailure of the instructor pilot to maintain directional control and properly supervise the landing. A contributing factor was the unavailability of brakes on the instructor's side (the right side) of the airplane.NTSB CHI99LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Evansville, INthe student pilot's inability to gain clearance between the airplane and the hanger. Factors contributing to this accident were the wet, grass landing surface, the student pilot's attempted turn to avoid the embankment drop off at the end of the runway, the…NTSB ATL99LA033Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Lantana, FLThe pilot's improper use of the flight controls during an attempted autorotation.NTSB MIA99FA043Accident · 3 fatalField investigationFinal reportCessna 402B · Pahokee, FLThe pilot's failure to maintain adequate altitude during the approach.NTSB CHI99LA050Accident · No injuriesLimited investigationFinal reportCessna 310 · Ashland, NEthe pilot's not refueling the airplane to avoid fuel exhaustion, and his inadequate preflight planning. A factor was fuel exhaustion.NTSB ATL99LA032Accident · No injuriesLimited investigationFinal reportCessna 310C · Ft Myers, FLThe inadequate preflight inspection of the airplane by the pilot and subsequent malfunction of the nose gear strut, and the pilot's failure to follow the landing checklist.NTSB SEA99FA018Accident · Minor injuriesField investigationFinal reportHughes 369D · Taholah, WATurbine wheel failure as the result of a low-cycle fatigue crack that initiated in a beyond-limits grinding gouge. Factors include improper maintenance by unknown parties and tree stumps that prohibited a successful emergency landing.NTSB NYC99LA035Accident · No injuriesLimited investigationFinal reportBeech 36 · Mathews, VAThe pilot's decision to land with less than full-down flaps. Contributing factors were the wet landing surface and the tree.NTSB NYC99IA036Incident · No injuriesIncident investigationFinal reportBoeing 737 · New York, NYThe Cessna pilot's incorrect visual identification of the Boeing 737's altitude, and decision to take evasive action that was not required, which resulted in the two airplanes coming within 500 feet horizontally, and 0 feet vertically of one another.NTSB FTW99TA046Accident · No injuriesFinal reportBell OH-58A · N. Little Rock, ARThe loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for the forced landing and the dark night light condition.NTSB SEA99LA019Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Carnation, WAThe pilot's failure to maintain clearance with a wire. Related factors were the pilot's performance of a low pass, a transmission wire, and difficulty encountered by the pilot in detecting the wire visually.NTSB NYC99LA034Accident · No injuriesLimited investigationFinal reportUnivair 7GC-AA · Garner, VAA jammed right wheel for undetermined reasons.NTSB MIA99WA042Accident · No injuriesForeign investigationPiper PA-38-112 · Marsh Harbor, BahamasNTSB FTW99FA044Accident · 1 fatalField investigationFinal reportBeech 58 · Newcastle, OKthe pilot's loss of control due to his inadvertent encounter with severe turbulence and wind shear during an instrument approach. Factors contributing to the accident were the severe turbulence and the wind shear.NTSB CHI99LA049Accident · No injuriesLimited investigationFinal reportCessna 150 · East Troy, WIthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind, and the ditch.