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 MIA90LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Orlando, FLFailure of the pilot to follow proper procedures.NTSB LAX90DUM03Accident · 1 fatalFinal reportParrigin RV-4 · Poway, CAThe pilot's performing low level acrobatic maneuvers and failure to maintain aircraft control.NTSB DEN90LA188Accident · No injuriesLimited investigationFinal reportCessna 150 · Marietta, OKThe loss of directional control by the pilot. The selection of unsuitable terrain is a factor.NTSB ANC90LA180Accident · No injuriesLimited investigationFinal reportCessna 185 · Upper Colleen, AKThe pilot-in-command's failure to select suitable terrain for landing. Contributing to the accident was the rough and uneven terrain.NTSB SEA90LA186Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Kamas, UTPoor inflight planning by the pilot. The airplane encountered a possible downdraft condition while maneuvering in mountainous terrain which resulted in an inflight collision with trees.NTSB SEA90LA184Accident · No injuriesLimited investigationFinal reportCessna 180 · Enterprise, ORThe pilot's failure to maintain directional control of the aircraft during landing.NTSB LAX90LA323Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Montague, CAThe pilot's failure to maintain directional control during landing rollout. A contributing factor was the student pilot's lack of experience performing landings.NTSB FTW90FA183Accident · 1 fatalField investigationFinal reportHughes 269A · Kingsville, TXThe fatigue failure of the left flange on the tail boom saddle fitting.NTSB FTW90DPJ12Accident · No injuriesFinal reportMassegee Rebel 300 · El Reno, OKFailure of the elevator control rod at the bell crank.NTSB ATL90LA172Accident · No injuriesLimited investigationFinal reportCessna 172RG · Ozark, ALInadequate engine overhaul procedures which allowed the installation of the engine plug without safety wire to hold it in place, and which resulted in oil starvation of the engine.NTSB SEA90LA187Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Park City, UTThe pilot's lack of understanding of aircraft performance and meteorological conditions when flying at high density altitude in close proximity to mountainous terrain.NTSB SEA90LA185Accident · No injuriesLimited investigationFinal reportCessna 180A · Paisley, ORPilot's selection of unsuitable terrain for a landing site.NTSB SEA90FA183Accident · 1 fatalField investigationFinal reportCessna 172-P · Hood River, ORThe pilot in command's encountering spatial disorientation and his failure to maintain airspeed.NTSB FTW90DRA10Accident · No injuriesFinal reportLockheed PV-2 · Conroe, TXThe engine starter remained engaged after engine start and the electrical system overheat.NTSB CHI90LA267Accident · No injuriesLimited investigationFinal reportCessna 182 · Troy, MIA loss of engine power due to failure of the rocker arm bosses on the #2 cylinder.NTSB ATL90LA187Accident · No injuriesLimited investigationFinal reportCessna 150J · Grantham, NCThe pilot's improper use of the rudder to maintain directional control and his premature lift-off, which resulted in a stall and collision with the ground.NTSB ANC90LA177Accident · No injuriesLimited investigationFinal reportHelio H-295 · Mcgrath, AKFuel contamination. A contributing factor was the inadequate aircraft preflight by the pilot.NTSB ANC90LA176Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Port Heiden, AKThe pilot-in-command's failure to maintain aircraft control during a strong crosswind.NTSB ANC90LA175Accident · No injuriesLimited investigationFinal reportCessna 206 · Puntilla Lake, AKAn inadequate preflight.NTSB LAX90DUJ08Accident · Serious injuriesFinal reportRockwell S-2R · Yuma, AZFailure of the pilot to select a cruise altitude which would ensure adequate clearance from obstructions. A factor in the accident was the dark night which inhibited the pilot's ability to see the obstruction.NTSB FTW90DPJ11Accident · No injuriesFinal reportDooley Mustang MII · Cashion, OKThe separation of a 14 inch section of one propeller blade due to previous damage.NTSB DEN90LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Springdale, ARPilot's loss of control of the aircraft, during landing, due to mechanical malfunction of the tailwheel assembly.NTSB CHI90LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIFuel exhaustion. Contributing factor was the unsuitable terrain.NTSB CHI90FA265Accident · 2 fatalField investigationFinal reportCessna 172M · Aberdeen, SDFailure to maintain a safe airspeed resulting in an inadvertent stall/spin.NTSB SEA90FA182Accident · 1 fatalField investigationFinal reportCessna 150M · Prospect, ORThe pilot's failure to maintain a proper altitude during his approach. The dark night condition was a contributing factor.NTSB NYC90FA220Accident · 2 fatalField investigationFinal reportCessna 152 · Plain City, OHPoor judgement of the pilot due to consumption of alcohol, flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft due to spatial disorientation. Factors related to the accident were: darkness,…NTSB FTW90FA181Accident · 1 fatalField investigationFinal reportCessna 152 · Blue Ridge, TXThe pilot's decision to perform buzzing type maneuvers, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB FTW90DRA09Accident · No injuriesFinal reportGrumman G-164A · Altair, TXThe pilot's use of improper terrain for takeoff.NTSB DEN90LA186Accident · Minor injuriesLimited investigationFinal reportBeech D17S · Englewood, COImproper planning/decision by the pilot and inadequate visual lookout by the vehicle driver, which resulted in their failure to assure clearance between the vehicle and aircraft. Factors related to the accident were: sunglare and the pilot's restricted view…NTSB BFO90LA075Accident · Serious injuriesLimited investigationFinal reportHughes 369E · Prestonburg, KYThe lost of engine power for undetermined reasons.NTSB ATL90LA171Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Americus, GAA low cycle fatigue failure of the left main landing gear spring.NTSB SEA90LA188Accident · No injuriesLimited investigationFinal reportPiper PA34-200T · Jackson, WYThe pilot misjudged the landing flare and landed hard.NTSB LAX90LA337Accident · No injuriesLimited investigationFinal reportCessna 172 · Fresno, CAThe pilot misjudged the flare altitude and failed to properly recover from a bounced landing.NTSB LAX90LA322Accident · Serious injuriesLimited investigationFinal reportCessna 152 · San Fernando, CAFuel exhaustion. Contributing factors related to the pilot's improper preflight preparation and improper in-flight planning.NTSB FTW90DPG15Accident · Serious injuriesFinal reportRotec Engineering Ralley III · Woodson, ARUndetermined.NTSB CHI90FA263Accident · 2 fatalField investigationFinal reportCessna 172N · Paris, ILThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors contributing to the accident were the fog and the dark night.NTSB CHI90DEM09Accident · 1 fatalFinal reportComben Bowers Flybaby IA · Cheboygan, MIUndetermined.NTSB ANC90LA178Accident · No injuriesLimited investigationFinal reportHelio H-391B · Circle, AKPilot-in-command's failure to maintain airplane control and the pilot's failure to identify the stall.NTSB ANC90LA174Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Healy, AKThe pilot-in-command's failure to maintian airspeed.NTSB ANC90LA172Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKFailure of the pilot to obtain or maintain adequate airspeed which resulted in a stall or mush.NTSB SEA90GA180Accident · 1 fatalFinal reportBell 204B · Keller, WAThe total loss of engine power due to turbine blade separation while the pilot was operating in the aircraft at a gross weight that exceeded performance specifications for existing meteorological conditions. Factors include the failure or inability to…NTSB LAX90LA321Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Novato, CAThe pilot's improper execution of the autorotation. Contributing to this accident was the excessive sink rate and misjudging of the altitude.NTSB FTW90LA180Accident · No injuriesLimited investigationFinal reportMooney M-10 · Roscoe, TXThe pilot's loss of directional control. A factor was: rough/uneven terrain.NTSB FTW90FA179Accident · 1 fatalField investigationFinal reportBeech 58 · Conway, ARThe pilot's failure to attain the proper touchdown point and his delayed decision to abort the landing. Factors were the weather conditions.NTSB FTW90FA178Accident · 1 fatalField investigationFinal reportBell B206LI · Port O'Connor, TXThe pilot's failure to maintain proper altitude. Factors were the pilot's decision to fly into the known adverse weather and the weather/light conditions.NTSB CHI90LA279Accident · No injuriesLimited investigationFinal reportCessna 177B · Kokomo, INExceeding the design stress limits of the aircraft while recovering from a loss of control in flight due to spatial disorientation. Factors related to the accident were delayed remedial action and inadequate supervision of an inexperienced pilot by the…NTSB ANC90LA171Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sparrevohn, AKThe pilot-in-command's failure to maintain directional control of the airplane during the takeoff roll. The rough/uneven gravel bar was a related factor.NTSB ANC90LA168Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot-in-command's improper in-flight planning and ultimate fuel exhaustion.NTSB SEA90LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Dillon, MTPilot misjudged the flare that resulted in a bounced landing.NTSB NYC90DEI02Accident · Serious injuriesFinal reportGrumman AA5B · Beachwood, OHThe engine failure due to an improper engine overhaul performed by unqualified persons. The unsuitable terrain was a factor.