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 MIA90LA182Accident · No injuriesLimited investigationFinal reportHiller OH-23C · Fort Pierce, FLLoss of engine power due to separation of the packing seal which seals the distribution zone pipe to the inlet manifold, for undetermined reasons resulting in a hard landing.NTSB DEN90LA185Accident · No injuriesLimited investigationFinal reportCessna 172M · Parker, COThe dual student pilot's improper use of the aircraft power plant controls, resulted in a complete loss of engine power.NTSB DEN90FA184Accident · 2 fatalField investigationFinal reportMorane-Saulnier MS760 · Albuquerque, NMFailure of the pilot to maintain a climb after takeoff, due to spatial disorientation. Factors related to the accident were: darkness, pilot fatigue, and the pilot's lack of recent experience in night flying operation.NTSB DEN90DTE08Accident · No injuriesFinal reportPiper PA-25-235 · Idalia, COThe encounter with an unfavorable wind, a dust devil. A factor was the inability of the pilot to maintain directional control.NTSB CHI90LA261Accident · No injuriesLimited investigationFinal reportPiper PA-601P · Monroe, MIA fatigue fracture of the torque link on the right landing gear strut scissor assembly.NTSB ATL90DLG02Accident · 1 fatalFinal reportCessna A188B · Aiken, SCThe pilot's delayed pull-up during an aerial application swath which resulted in the collision with a static wire associated with electrical transmission lines.NTSB SEA90LA178Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Elk Mountain, WYThe pilot's failure to maintain flying speed while at an altitude that did not provide adequate terrain clearance for a safe stall recovery.NTSB NYC90IA219Incident · Minor injuriesIncident investigationFinal reportBoeing 727-231 · New York City, NYThe exhaust pipe fire in the APU which resulted in an unauthorized evacuation of the airplane by the passengers.NTSB LAX90FA320Accident · 2 fatalField investigationFinal reportCessna A152 · Tucson, AZFailure of the pilot to recover from a spin. Factors related to the accident were: the pilot's failure to assure there was adequate altitude to recover from an inadvertent or intentional spin, and his lack of recent expereince in the type of operation.NTSB LAX90DJA03Accident · Serious injuriesFinal reportBell 206B · Oahu, HIThe passenger's failure to follow boarding instructions.NTSB FTW90FA177Accident · Serious injuriesField investigationFinal reportPiper PA-32RT-300T · Addison, TXFatigue failure of the throttle cable. Factors related to the accident were: darkness and objects (fence and utility poles) in the emergency landing area.NTSB SEA90LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Lewiston, IDThe failure of a nose landing gear fork, which resulted in the pilot's loss of directional control, and a nose-over after an excursion from the runway.NTSB SEA90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Ogden, UTThe failure of the pilot to correct the position of the fuel tank selector, causing erratic engine operation and loss of power.NTSB NYC90LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Quarryville, PAThe pilot in commands failure to maintain airspeed while climbing to avoid wires.NTSB NYC90LA217Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Red Hook, NYThe pilot's loss of directional control and departure off the side of the runway during the landing roll, resulting in a collision with a tree. Contributing to the accident was the pilot's lack of expereince in the aircraft.NTSB LAX90LA325Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-34 · Hemet, CAImproper compensation for wind conditions.NTSB LAX90LA319Accident · 1 fatalLimited investigationFinal reportRobinson R-22 · Long Beach, CAThe pilot's inadequate passenger briefing, and his failure to provide proper assistance to the exiting passenger.NTSB FTW90DRA08Accident · No injuriesFinal reportBlaine Laux Pitts S-1 · Edna, TXA power loss due to failure of a connecting rod bolt. A factor was the soft terrain in which the forced landing was performed.NTSB FTW90DPG16Accident · Serious injuriesFinal reportEipper Quick Silver MX II · Tontitown, ARA partial power loss for undetermined reasons and the pilot's poor flare during the forced landing.NTSB FTW90DPA08Accident · Minor injuriesFinal reportMorris Avid Flyer · Kerens, TXThe pilot's improper compensation for the wind conditions and the resultant inadvertent stall. Factors related to the accident were: the gusty crosswind condition and the pilot's extension of full flaperons before descending to the proper altitude.NTSB DEN90LA183Accident · 1 fatalLimited investigationFinal reportBeech E 33 · Tulsa, OKThe pilot's failure to select the right tank prior to the approach resulting in fuel starvation.NTSB CHI90LA262Accident · Serious injuriesLimited investigationFinal reportNational Balloon AX-7 · Altoona, IAThe passenger's inadvertent contact with a propane tank during a bounced landing which resulted in serious injury to the passenger.NTSB CHI90LA260Accident · No injuriesLimited investigationFinal reportCessna 152 · Garrison, MNInadequate inspection of the aircraft.NTSB CHI90LA258Accident · No injuriesLimited investigationFinal reportCessna 177A · Perry, MIThe loss of engine power due to the pilot's inaccurate fuel consumption calculations.NTSB BFO90DID02Accident · 2 fatalFinal reportCessna 182R · Evington, VAThe pilot's failure to maintain control of the aircraft because of spatial disorientation. A contributing cause is failure of the vacuum system.NTSB ATL90LA169Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Goldsboro, NCThe pilot's failure to maintain control of the airplane which resulted in an inadvertent stall/spin. A factor related to the accident was: control interference by the passenger.NTSB ANC90LA170Accident · Serious injuriesLimited investigationFinal reportBell 206B · Kokhanok, AKThe failure of the compressor end of the air compressor scroll to tee tube assembly causing the engine to spool down. The forced landing in eneven, unprepared, and lightly forested terrain were factors.NTSB SEA90LA179Accident · No injuriesLimited investigationFinal reportCessna 182P · Lummi Island, WAThe pilot's failure to maintain directional control while applying brakes after landing.NTSB NYC90LA216Accident · No injuriesLimited investigationFinal reportCessna C337 · Manville, NJThe pilot's failure to secure his seat which slipped back during the take off run.NTSB NYC90LA214Accident · No injuriesLimited investigationFinal reportCessna 120 · Southbridge, MAThe pilot improper starting procedures.NTSB NYC90LA213Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Farmingdale, NJThe pilot's exceeding a proper touchdown point. A factor in the accident was the pilot's misreading wind information.NTSB NYC90FA215Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300 · Montgomery, NYAn inadequate preflight by the pilot which resulted in a power loss due to fuel exhaustion.NTSB LAX90LA314Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Barbara, CAA disconnect of the throttle control.NTSB FTW90FA176Accident · 2 fatalField investigationFinal reportBeech 36 · Baird, TXThe pilot-in-command failed to maintain control of the airplane while flying in severe weather and instrument meteorological conditions. The adverse weather conditions were a factor.NTSB DEN90FA182Accident · 3 fatalField investigationFinal reportStinson 108-1 · Gallup, NMThe pilot inadvertently stalling his aircraft at an insufficient altitude to effect a recovery. A factor was high density attitude.NTSB CHI90DCJ02Accident · 1 fatalFinal reportAero Commander Calair A9B · Ord, NEThe pilot's failure to maintain aircraft control during low altitude maneuvering.NTSB BFO90FA074Accident · 1 fatalField investigationFinal reportBeech C35 · Forest Hill, MDThe pilot's failure to maintain aircraft control during the turn from base to final approach. A factor was the pilot's abrupt aircraft handling during the turn.NTSB ATL90LA170Accident · No injuriesLimited investigationFinal reportCessna 188B · Elizabeth City, NCThe pilot's inadequate preflight planning and compensation for wind conditions and the subsequent loss of aircraft control during takeoff. Existing crosswinds and gusts were factors in the accident.NTSB ANC90LA173Accident · 2 fatalLimited investigationFinal reportPiper PA-32RT-300T · Glacier Island, AKUndetermined mechanical failure(s) that resulted in loss of engine power, smoke in the cockpit, and a subsequent emergency descent for a forced landing (ditching) at sea. The lack of suitable terrain for a forced landing was a related factor.NTSB ANC90FA167Accident · 2 fatalField investigationFinal reportTaylorcraft DCO-75 · Mckinley Park, AKFailure of both pilots to maintain adequate visual lookout to see-and-avoid other aircraft.NTSB MIA90LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Plymouth, FLThe failure of the pilot to arrest the high rate of descent prior to touchdown.NTSB LAX90LA318Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Trona, CAFailure of the pilot to maintain airspeed and an abrupt manuever which resulted in an inadvertent stall and spin. Contributing to the accident was the low altitude of the airplane which did not allow adequate time to perform the necessary remedial actions.NTSB LAX90LA317Accident · Serious injuriesLimited investigationFinal reportRobinson R22A · Beatty, NVThe pilot's selection of an inadequate cruise altitude and his failure to maintain adequate rotor RPM. Contributing factors related to the high density altitude, rising terrain, and the pilot's delayed and improper use of the collective.NTSB LAX90FA316Accident · 1 fatalField investigationFinal reportEnstrom F28C · Santa Paula, CAThe excessive approach speed to the pinnacle landing point and the pilot's delayed landing flare. Factors in the accident were: lack of total experience in this type of operation.NTSB ATL90LA168Accident · Serious injuriesLimited investigationFinal reportSchleicher ASK-21 · Memphis, TNAn inflight collision with a tree due to misjudging his glidepath.NTSB ANC90LA169Accident · No injuriesLimited investigationFinal reportBeech H-18S · Deering, AKThe pilot-in-command's failure to maintain directional control of the airplane on landing.NTSB SEA90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Lewistown, MTThe pilot did not maintain an adequate lookout while maneuvering which resulted in a collision with a transmission wire.NTSB SEA90LA174Accident · No injuriesLimited investigationFinal reportPiper PA-32-300RT · Glenrock, WYFuel exhaustion resulting from the pilot's inadequate preflight planning/preparation. Unsuitable terrain was a factor related to the accident.NTSB MIA90WA178Accident · No injuriesForeign investigationBeech 58 · Union Island, St. Vincent & GrenadinesNTSB MIA90LA179Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Geneva, FLThe pilots failure to retract the flaps to the takeoff setting during a touch-and-go landing.