NTSB investigations, 1990
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\") = 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 NYC90LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Franconia, NHThe landing of the airplane in unsuitable terrain, due to the mechanical failure of the engine center muffler baffle, which blocked the exhaust flow, resulting in a loss of power.NTSB NYC90FA227Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Eliot, METhe pilot's failure to abort the takeoff. Factors were the over weight condition, upsloping runway, premature rotation, and the pilot's lack of experience in type aircraft and general aviation operations.NTSB LAX90DXQ05Accident · Minor injuriesFinal reportGlaser-Dirks DG 400/17 · Truckee, CAThe uncommanded deployment of the right spoiler system due to the absence of a spring pin not fitted to the quick disconnect as recommended which resulted in the pilot losing control of the glider during a critical phase of flight.NTSB CHI90LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNThe pilot in command attempting to force the airplane onto the runway.NTSB CHI90GA273Incident · No injuriesFinal reportPiper PA-3O · Cape Girardeau, MOExcessive play in the landing gear extension linkage. A factor in the incident was unreliability of the gear indicating system.NTSB BFO90LA078Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82A · Bealeton, VAThe pilot's failure to maintain a vigilent watch for other aircraft operating on the uncontrolled airport. The uneven terrain on the airport restricted visibility and contributed to the accident. Another contributing factor was the improper signals given by…NTSB BFO90FA077Accident · 1 fatalField investigationFinal reportChristen Industries A-1 · Middle River, MDThe pilot delayed his recovery from an intentional spin manuever until there was insufficient altitude to recover.NTSB ATL90LA178Accident · No injuriesLimited investigationFinal reportCessna 150J · Albemarle, NCThe pilot's not obtaining an adequate fuel supply for his planned flight, resulting in fuel exhaustion.NTSB ANC90LA184Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · King Salmon, AKThe pilot-in-command's failure to maintain airplane control during the takeoff roll, and failure of not attaining airspeed on takeoff.NTSB ANC90LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Coal Creek, AKThe pilot's failure to adequately remove snow from the airplane and his delay in aborting the takeoff.NTSB SEA90LA195Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Enumclaw, WAThe pilot did not maintain directional control of the airplane during the landing roll in gusting wind condition.NTSB NYC90LA224Accident · Minor injuriesLimited investigationFinal reportRockwell 690B · North Castle, NYThe pilot's improper aircraft preflight (fuel cap not properly secured) which resulted in fuel siphoning and fuel exhaustion.NTSB NYC90FA226Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Smithfield, PAThe failure of both pilots to maintain aircraft control while conducting training maneuvers at an altitude that precluded a safe recovery.NTSB NYC90FA225Accident · 4 fatalField investigationFinal reportPiper PA-30 · Berlin, VTThe non-instrument rated pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain aircraft control after becoming spatially disoriented. Factors related to the accident were: the adverse weather conditions, and…NTSB MIA90LA186Accident · No injuriesLimited investigationFinal reportCessna 421B · Pompano Beach, FLThe failure of the pilot to initiate a go-around due to being high on final approach and as a result, failure to attain the correct point of touchdown and his excessive application of brakes which resulted in failure of the right main tire and loss of…NTSB LAX90LA334Accident · No injuriesLimited investigationFinal reportCessna 172M · Orovada, NVThe pilot's failure to initiate a go-around. His lack of recent experience in type of operation, (landings), and the inadvertent ground loop were factors in the accident.NTSB LAX90LA333Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Reno, NVThe pilot's failure to maintain sufficient airspeed resulting in an inadvertent stall. A factor in the accident was the strong crosswind conditions.NTSB LAX90DUQ03Accident · Serious injuriesFinal reportSchleicher ASW-12 · California City, CAAn inflight loss of control due to a disconnected elevator control surface and an improper preflight inspection of the flight controls by the glider pilot.NTSB FTW90LA184Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Fort Worth, TXThe pilot in command's failure to maintain directional control. The crosswind was a factor.NTSB DEN90FA192Accident · 1 fatalField investigationFinal reportCessna 182P · Marble, COFailure of the private pilot (student pilot) to maintain sufficient altitude and airspeed above mountainous terrain, and inadequate supervision by the instructor pilot (CFI) and her delay in taking remedial action. Factors related to the accident were: the…NTSB CHI90LA270Accident · Serious injuriesLimited investigationFinal reportBeech F-33A · Osage Beach, MOThe pilot's failure to establish a proper glide path, resulting in contact with trees short of the intended runway.NTSB CHI90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Wayne, INThe failure of the pilot of the accident airplane to maintain sufficient speed for flight. The pilots lack of total experience and the crosswinds that were present during the approach and the attempted go-around are contributing factors to the accident.NTSB CHI90DEP11Accident · Minor injuriesFinal reportVarga Kachina 2150A · Neenah, WIThe pilot's misjudgement of the fuel supply, and his failure to refuel the aircraft. Contributing to the accident was the unsuitable, soft terrain encountered.NTSB ATL90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Brookley, GAFuel exhaustion. Factors include improper planning/decision by the pilot-in-command.NTSB ATL90LA175Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Midfield, ALThe pilot's inadequate assessment of deteriorating weather conditions and his resultant flight into areas of low clouds. The safety board believes that the pilot's overall lack of experience was a factor in the accident.NTSB ATL90LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Palmetto, GAThe number two cylinder exhaust valve sticking in the closed position, which resulted in a partial power loss during the takeoff. A factor in the accident was the pilot's improper preflight inspection, in that he did not correctly analyze the engine problem…NTSB ATL90IA177Incident · No injuriesIncident investigationFinal reportFairchild SA 227 · Morrisville, NCThe fatigue failure of the rudder trim control rod end.NTSB ANC90LA186Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot's inadequate removal of snow and ice prior to takeoff.NTSB SEA90LA193Accident · No injuriesLimited investigationFinal reportCessna 170 · Havre, MTThe selection of the wrong runway by the owner/student pilot and his failure to compensate for the wind during landing ground roll.NTSB MIA90LA185Accident · No injuriesLimited investigationFinal reportCessna A188B · Vicksburg, MSFailure of the pilot to avoid a mud hole on the runway during the ground roll to takeoff.NTSB LAX90LA341Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · Cloverdale, CAThe improper procedure employed by the student pilot. Contributing to the accident was failure of the CFI to adequately guard the flight controls to apply timely corrective actions.NTSB LAX90LA328Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hayward, CAThe failure of the airplane's main landing gear bolt/nut plate attachment assembly. Contributing factors related to the improper installation (threading) of the gear bolt/nut assembly.NTSB LAX90LA327Accident · No injuriesLimited investigationFinal reportCessna 150L · Palm Springs, CAFuel exhaustion. Contributing factors related to the pilot's improper preflight preparation, and his lack of total experience.NTSB LAX90FA331Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Flagstaff, AZVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude during the approach to land. Factors related to the accident were: darkness, the adverse weather conditions, and failure of…NTSB FTW90GA185Accident · No injuriesFinal reportHughes 369HS · New Orleans, LAThe pilot's failure to maintain rotor RPM. A factor in the accident was the lose of engine power due to fuel starvation.NTSB CHI90LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Huntington, INThe student pilot's improper preflight planning ensuring sufficient fuel for the intended flight.NTSB ANC90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Egegik, AKThe improper use of elevator controls by the pilot.NTSB SEA90LA192Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Troutdale, ORPassengers failure to maintain clearance from the turning propeller. A factor in the accident was his diverted attention to a helicopter on the ground nearby with the engine running.NTSB MIA90WA184Accident · 1 fatalForeign investigationCessna 402B · Santo Domingo, Dominican RepublicNTSB DEN90LA191Accident · No injuriesLimited investigationFinal reportCessna 172L · Mason, TXThe failure of the pilot to maintain an adequate visual lookout.NTSB DCA90MA055Accident · 1 fatalMajor investigationFinal reportBoeing 707-321B · Marana, AZImproper preflight planning/preparation by the pilot, and his failure to use a checklist. Factors related to the accident were: the faa's inadequate surveillance of the operation, the faa's insufficient standards/requirements, the pilot's operation of the…NTSB ATL90LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Hertsboro, ALFatigue failure of the propeller blade which resulted from improper overhaul procedures, and the absence of oil in the propeller hub which would allow the detection of blade cracks.NTSB ANC90LA182Accident · No injuriesLimited investigationFinal reportCessna 180-A · Wood Creek, AKThe pilot-in-command's failure to attain proper lift off airspeed. Contributing to the accident was rough and uneven terrain.NTSB SEA90LA190Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Christmas Valle, ORThe pilot's inadequate preflight and failure to maintain alignment during landing ground roll. Factors in the accident were the contaminated fuel and the soft terrain on the landing surface.NTSB NYC90FA223Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Livingston, NYThe pilot failed to maintain control of the aircraft while maneuvering for an ILS approach. Factors related to the accident were the pilot's lack of recent instrument flight experience, low cloud ceilings and fog, and failure to follow IFR procedures.NTSB LAX90LA326Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Mount Wilson, CAThe pilot's inadvertent flight into IMC. Contributing factors related to the pilot's failure to request in-flight weather avoidance assistance and his misjudged evaluation of the en route weather.NTSB LAX90LA324Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Watsonville, CAImproper handling of the aircraft by the student pilot, which resulted in his failure to attain sufficient airspeed to climb after takeoff, and the instructor's (cfi's) inadequate supervision.NTSB DEN90IA189Incident · Minor injuriesIncident investigationFinal reportBoeing 737-222 · Denver, COThe failure of the flight crew to follow emergency procedures/directives. Factors were the failure of the aircraft electrical system (relays) and the failure of the company to provide a jetway operator.NTSB BFO90FA076Accident · 1 fatalField investigationFinal reportPiper PA-601P · Wiley Ford, WVThe pilot's improper IFR procedure by not maintaining sufficient altitude, while circling to land. Factors related to the accident were: the low ceiling and visibility conditions in fog.NTSB SEA90LA189Accident · No injuriesLimited investigationFinal reportCessna TR182 · Everett, WAPilot did not maintained an adequate airspeed during the initial climb. The pilot failed to maintain directional control.