NTSB investigations, 1990
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\") = 1990 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") = 1990 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 NYC91DNE01Accident · No injuriesFinal reportCraig A. Gordon Teenie TWO · Oxford, CTThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall and hard landing. Factors related to the accident were: the power loss and improper maintenance on the engine.NTSB MIA91WA030Incident · No injuriesForeign investigationBoeing 727-200 · Curacao, NTNTSB LAX91LA034Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350-B · Kahului, HIThe pilot's inadvertent deactivation of the helicopter's hydraulic boost system and his improper remedial action thereafter to the inflight situations which he created. A contributing factor was related to the manufacturer's inadequate location and design…NTSB LAX91DUJ03Accident · No injuriesFinal reportAir Tractor AT-302 · Somerton, AZThe failure of the number 3 exhaust valve which led to an engine failure and subsequent crash landing.NTSB BFO91LA015Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Milton, KYThe in-flight failure of both engines due to the pilot's mismanagement of the fuel system.NTSB ATL91TL#01Accident · No injuriesClass 3Final reportAero Commander 690A · Montgomery, ALNTSB SEA91LA016Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Brigham City, UTThe pilot did not maintain a proper climb rate.NTSB SEA91LA015Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Port Townsend, WAThe pilot's failure to use carburetor heat which resulted in a loss of engine power and a forced landing.NTSB NYC91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · North Hampton, MALoss of directional control after landing.NTSB NYC91DNA01Accident · No injuriesFinal reportBell 47-G3-B · Nantucket, MAA hard landing, after a power loss due to improper use of the carburetor heat control by the pilot.NTSB LAX91WA031Accident · No injuriesForeign investigationBritten-Norman BN-2A · Pohnpei (Pacific Ocean)NTSB BFO91LA014Accident · No injuriesLimited investigationFinal reportHughes 269C · Louisville, KYFatigue failure of the number 1 cylinder connecting rod.NTSB LAX91LA029Accident · No injuriesLimited investigationFinal reportCessna 150F · San Diego, CAThe failure of the student pilot to maintain an adequate airspeed while maneuvering in the traffic pattern; maintain control of the aircraft and the inadvertent stall mush. A factor in the accident was the pilot's limited total expereince.NTSB CHI91LA027Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Lindstrom, MNLeft engine failure for an undetermined reason. A factor related to the accident was: unsuitable terrain.NTSB NYC91LA027Accident · No injuriesLimited investigationFinal reportCessna 404 · Pittsburgh, PAA failure of nose landing gear retraction cylinder attach points which allowed the nose landing gear to collapse.NTSB MIA91LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Pierce, FLImproper preflight decision of the instructor pilot to allow the student to takeoff from the soft grass runway and his failure to abort the takeoff.NTSB MIA91GA025Accident · 3 fatalFinal reportBeech A-90 · Crestview, FLThe pilot-in-command/cfi improper supervision of the dual student. This resulted in an in flight loss of control, and collision with terrain for failure to maintain minimum control airspeed (VMC) while conducting a simulated emergency procedure.NTSB CHI91LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe student pilot's improper recovery from a bounced landing, resulting inadvertent porpoising.NTSB ANC91LA013Accident · No injuriesLimited investigationFinal reportCessna U-206 · Montague Island, AKPilot-in-command's failure to maintain aircraft control during landing.NTSB LAX91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Prescott, AZThe failure of the main landing gear trunion attach fitting for undetermined reasons.NTSB FTW91LA014Accident · No injuriesLimited investigationFinal reportCessna 140 · Roanoake, TXThe pilot's failure to maintain directional control. A factor was his lack of flying tail wheel (conventional) gear airplanes.NTSB DEN91FA017Accident · 4 fatalField investigationFinal reportCessna T210L · Aspen, COImproper planning/decision by the pilot and his failure to maintain adequate airspeed, while turning over high terrain beside the airport, which resulted in an inadvertent stall. Factors related to the accident were: excessive gross weight of the aircraft,…NTSB BFO91LA012Accident · Minor injuriesLimited investigationFinal reportTaylor Rotorway Executive · Keysville, VAA jammed engine throttle cable. Factors related to the accident are inadequate maintenance inspection and low rotor RPM.NTSB NYC91LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Saxton, PAAn engine failure due to fuel starvation and the subsequent forced landing in unsuitable terrain. Factors related to the accident were the cfi's inadequate execution of emergency procedures.NTSB MIA91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLPilot-in-command's failure to land on a runway that was more aligned with the wind. Factors were: crosswind and lack of total experience.NTSB LAX91LA027Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Dana Point, CAThe pilot's improper fuel consumption calculations.NTSB FTW91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fort Worth, TXThe pilot's misjudgment of airplane attitude, airspeed and distance while on final approach. A factor was the instructor pilot's inadequate supervision.NTSB DEN91LA016Accident · No injuriesLimited investigationFinal reportFogarty Pitts S1SEW · Bennett, COThe pilot's failure to refuel the airplane and the resultant fuel exhaustion induced power loss. A factor was the soft terrain in which the forced landing was performed.NTSB CHI91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oswego, KSFuel starvation due to improper placement of the fuel tank selector by the pilot.NTSB CHI91FA026Accident · 1 fatalField investigationFinal reportCessna 182D · Walker, MIVFR flight into IMC conditions. Factors related to the accident are failure to obtain a preflight weather briefing, becoming lost/disoriented, induction air filter icing, excessive workload, and lack of total experience in type of operation.NTSB ATL91IA017Incident · No injuriesIncident investigationFinal reportFokker F28 MK0100 · Atlanta, GAFrozen moisture in the stabilizer actuator hydraulic servo valve which resulted in reduced movement of the servo valve and limited its ability to respond to flight control inputs. The lack of response from the servo valve resulted in the jammed stabilizer…NTSB LAX91TL#02Accident · Minor injuriesClass 3Final reportMcDonnell Douglas 369E · Llano, CANTSB LAX91LA026Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Paso Robles, CAThe pilot's delay in taking appropriate remedial action. A factor in the accident was the flight's encounter with a tailwind during the termination phase of the auto rotation.NTSB LAX91LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Pacoima, CAAn engine failure for undetermined reasons.NTSB DEN91DQA01Accident · 1 fatalFinal reportYoung 2/3 Scale · Alamogordo, NMPartial loss of engine power for an undetermined reason, improper planning/decision by the pilot, and the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB ATL91IA016Incident · No injuriesIncident investigationFinal reportSaab-Scania 340A · Memphis, TNThe pilot's failure to follow approved procedures for troubleshooting inflight maintenance problems and improperly used the flight and engine controls.NTSB NYC91LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Zanesville, OHImproper use of carburetor heat by the pilot, which resulted in a loss of power due to carburetor ice. Factors related to the accident were: carburetor icing (weather) conditions and soft terrain in the emergency landing area.NTSB MIA91FA023Accident · 3 fatalField investigationFinal reportCessna 421B · Flamingo, FLAn undetermined airframe/component/system failure/malfunction, which resulted in a fuel fed fire in the left wing.NTSB FTW91FA012Accident · 5 fatalField investigationFinal reportPiper 601P · Nacogdoches, TXFailure of the pilot to follow IFR procedures and maintain the proper altitude. Factors related to the accident were: the adverse weather conditions, dark night, low fuel state of the aircraft, and trees at the accident site.NTSB CHI91DEP02Accident · Serious injuriesFinal reportCessna 172P · Hayward, WIThe pilot-in-command's intentional flight into known adverse weather.NTSB BFO91LA011Accident · No injuriesLimited investigationFinal reportFairchild SA227-AC · Covington, KYThe pilot-in-command's failure to extend the landing gear prior to touchdown. Checkride-induced pressure was a contributing factor, and inadequate supervision by the check pilot was a factor.NTSB SEA91LA014Accident · No injuriesLimited investigationFinal reportCessna 402B · Pocatello, IDThe loss of engine power due to a burned piston resulting from arcing and partial failure of the left magneto because of improper overhaul, the contamination of the right magneto and improper adjustment of the fuel system at the last major engine overhaul;…NTSB SEA91LA013Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B Lama · Trout Lake, WAThe pilot's failure to maintain clearance from an obstacle.NTSB NYC91FA025Accident · 2 fatalField investigationFinal reportBeech A36 · Bradford, PAThe pilot's failure to maintain adequate terrain clearance while maneuvering to land during an instrument approach. Factors related to the accident were: the pilot's failure to obtain a weather briefing prior to departure, his delayed decision to make an…NTSB CHI91LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Latham, KSFailure of the pilot to maintain a proper altitude.NTSB BFO91DID01Accident · 2 fatalFinal reportAeronca Champion 7BCM · Suffolk, VAA loss of engine power due to low cylinder compression. The low compression was a result of exhaust valve leakage and inadequate maintenance and inspection. In addition, the pilot failed to maintain adequate airspeed which resulted in the airplane stalling.NTSB DEN91LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Abilene, TXAn in flight encounter with turbulence. Factors were the pilot's inadequate aircraft preflight.NTSB ANC91LA012Accident · No injuriesLimited investigationFinal reportCessna 170A · Healy, AKThe loss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB ANC91LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Thorne Bay, AKThe pilot's delay in aborting the takeoff.NTSB MIA91IA022Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · San Juan, PRThe improper use of aileron trim and the improper preparation for auto pilot disconnect by the flight crew combined with excessive forces applied by the aileron trim system resulting in a departure from controlled flight. Contributing factors to the incident…