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 LAX90LA335Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Beatty, NVThe pilot's selection of unsuitable terrain on which to land. Loose shale rock and sloping downhill terrain were factors in the accident.NTSB LAX90LA315Accident · Serious injuriesLimited investigationFinal reportCessna U206F · Las Vegas, NVThe pilot's loss of visual references during a night approach and his failure to detect and correct a descent. A factor in the accident was the dark night lighting conditions.NTSB CHI90LA259Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Lebanon, ILthe loss of engine power for undetermined reasons while executing a go-around with insufficient runway remaining for a forced landing. A factor in the accident was the structures at the end of the runway that the pilot was attempting to avoid. This report was…NTSB CHI90LA257Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Clutier, IAThe pilot's failure to compensate for wind conditions.NTSB ATL90LA167Accident · No injuriesLimited investigationFinal reportWSK PZL-104 · Smithfield, NCThe pilot's failure to properly preflight fuel requirements for the additional landing. The engine quit due to fuel exhaustion.NTSB ATL90FA163Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-36 · Nashville, TNThe company/operator management's decision to operate the aircraft with a known deficiency without further maintenance, the pilot's improper planning/decision and the pilot's failure to abort the takeoff (while there was sufficient runway remaining). Factors…NTSB SEA90LA175Accident · No injuriesLimited investigationFinal reportMooney M-20E · Cheyenne, WYPilot's failure to extend the landing gear prior to landing after having been distracted by traffic. A mitigating factor in this accident was the fact that the gear warning horn did not function.NTSB NYC90LA212Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Elliotville, MEA power loss for unknown reasons over unsuitable terrain.NTSB FTW90LA175Accident · No injuriesLimited investigationFinal reportBeech C55 · Weatherford, TXThe fuel starvation induced power loss to the left engine, which resulted from the improper fuel tank being selected by the PIC.NTSB DEN90LA181Accident · No injuriesLimited investigationFinal reportCessna T210N · Durango, COThe loss of control of the airplane when the pilot encountered turbulence on short final to land.NTSB CHI90LA256Accident · Serious injuriesLimited investigationFinal reportBoeing B75N1 · Marseilles, ILThe pilot-in-command's failure to maintain adequate visual outlook to avoid collision with a wire while conducting intentional low level flight.NTSB CHI90LA255Accident · Minor injuriesLimited investigationFinal reportBeech A23A · Newaygo, MIThe student pilot's improper level-off and recovery from a bounced landing which resulted in a loss of control. In addition, an unqualified person was coaching the student from the ground.NTSB FTW90DPG14Accident · Minor injuriesFinal reportGrumman G-164B · Dumas, ARThe inadvertent stall encountered during the turn to reverse direction.NTSB ANC90LA165Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Blair Lakes, AKThe pilot's failure to maintain adequate lookout during the post-landing taxi. Contributing to the accident were the rough terrain, the pilot's lack of total experience, and his lack of familiarity with the geographic area.NTSB NYC90LA211Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Peters Twp, PAThe pilot in commands failure to maintain airspeed on final approach resulting in an inadvertent stall and hard landing.NTSB LAX90FA311Accident · 1 fatalField investigationFinal reportCessna 411 · Fallon, NVFailure of the pilot to perform emergency procedures for loss of engine power (including his failure to feather the propeller of the affected engine). Factors related to the accident were: inadequate maintenance, contamination in the fuel system, and overheat…NTSB LAX90FA310Accident · 1 fatalField investigationFinal reportSchempp-Hirth NIMBUS-2C · California City, CAThe pilot's improper decision to execute the rapid climbing turn maneuver at an insufficient airspeed. Contributing to this accident was the premature dumping of the glider's water ballast.NTSB LAX90DVA11Accident · Minor injuriesFinal reportBob Sandlin BOB'S Executive · Sanger, CAFailure to maintain directional control during a hover.NTSB ANC90LA179Accident · No injuriesLimited investigationFinal reportCessna U206 · Twin Lake, AKInadequate compensation for wind condition.NTSB ANC90FA161Accident · 3 fatalField investigationFinal reportPiper PA-31-325 · Kaltag, AKFailure of the pilot to maintain adequate altitude after becoming distracted with an engine problem. Factors related to the accident were: loss of power in the #2 engine for an unknown reason and the low overcast condition.NTSB SEA90LA173Accident · No injuriesLimited investigationFinal reportCessna 172P · Granite Falls, WAThe pilot in command's use of excessive flaps for takeoff resulting in loss of climb performance.NTSB NYC90LA210Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Mannington Twp, NJThe pilot stalled and lost control of the airplane while taking off.NTSB LAX90LA312Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Lancaster, CAThe pilot's decision to attempt a takeoff when the aircraft capability was exceeded by weight and density altitude.NTSB LAX90LA308Accident · No injuriesLimited investigationFinal reportCessna 182P · Fernley, NVThe pilot's final approach airspeed was excessive.NTSB FTW90LA173Accident · No injuriesLimited investigationFinal reportBeech BE19 · Dallas, TXThe instructor pilot's failure to maintain crew coordination in the cockpit, and the student pilot's premature retraction of the flaps during a critical maneuver. Factors were the certified flight instructors inadequate supervision and the inadvertent low…NTSB FTW90LA162Accident · No injuriesLimited investigationFinal reportPiper PA28-201T · Heber Springs, ARThe pilot's failure to conduct a thorough preflight and his attempt to execute a turn at high speed.NTSB DEN90LA180Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Canon City, COThe pilot's failure to maintain an adequate pattern altitude and the possible existence of adverse winds due to the surrounding terrain.NTSB CHI90FA252Accident · 1 fatalField investigationFinal reportCessna 172N · Pine City, MNThe pilot's misjudgement of the fuel supply, and his failure to maintain adequate airspeed. A factor was the pilot's lack of experience in the make and model of aircraft.NTSB ANC90LA163Accident · No injuriesLimited investigationFinal reportCessna 150-L · Anchorage, AKThe pilot-inn-command's failure to maintain flying speed. Contributing to the accident was improper altitude.NTSB ANC90LA160Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Cordova, AKFuel exhaustion due to the pilot-in-command's improper preflight preparation and planning.NTSB ANC90FA164Accident · 5 fatalField investigationFinal reportCessna P206C · Talkeetna, AKThe pilot-in-command's continued VFR flight into instrument meteorological conditions, and failure to maintain adequate altitude for terrain clearance. Factors to the accident were the adverse weather conditions, mountainous terrain, and the dark night.NTSB NYC90LA209Accident · 1 fatalLimited investigationFinal reportCessna 172L · Montauk, NYPilot failed to attain airspeed during a go around, resulting in the airplane stalling at a low altitude. Contributing factor was the pilot's attention was diverted to airport maintenance personnel working near the approach end of the runway.NTSB MIA90LA181Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Opa-Locka, FLEngine failure due to lack of oil supply to the number 3 cylinder connecting rod for undetermined reasons. This allowed the connecting rod end cap to separate through the case resulting in oil exhaustion.NTSB FTW90LA174Accident · Minor injuriesLimited investigationFinal reportCessna C172N · Marietta, OKFailure of the pilot to attain the proper climb rate after takeoff resulting in the aircraft colliding with trees at the departure end of the runway. Contribuing to the accident was the pilot in commands failure to account for high density altitude.NTSB CHI90LA254Accident · No injuriesLimited investigationFinal reportCessna 177 · Farmington, MOFuel exhaustion due to unknown reasons.NTSB NYC90LA208Accident · No injuriesLimited investigationFinal reportPiper J5 CUB · Douglas, MAA total engine failure when the #3 exhaust valve failed, causing internal damage to the engine. Factors related to the accident were: the pilot had to make a forced landing in unsuitable terrain.NTSB NYC90LA207Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainville, CTThe pilot lost control of the airplane during a cross wind landing, subsequently running off the side of the runway and collided with the terrain.NTSB MIA90TL#06Accident · Minor injuriesClass 3Final reportPiper PA-28-181 · Labelle, FLNTSB LAX90T#A07Accident · Minor injuriesClass 3Final reportBell 212 · Yosemite, CANTSB LAX90LA313Accident · No injuriesLimited investigationFinal reportCessna 182C · Reno, NVFuel exhaustion and the pilot's failure to perform refueling.NTSB LAX90LA309Accident · No injuriesLimited investigationFinal reportBoeing E75 · Petaluma, CAThe pilot failed to maintain directional control by improperly using the rudder.NTSB LAX90DUG09Accident · Minor injuriesFinal reportMiles Atwood 1 · Chino, CALoss of engine power due to a fuel line separation.NTSB CHI90LA253Accident · No injuriesLimited investigationFinal reportPiper PA25-235 · Logansport, INThe engine failed due to fuel exhaustion. The presence of standing corn in the touchdown area was a factor.NTSB CHI90LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Elwood, INThe pilot's failure to abort takeoff.NTSB CHI90DCQ01Accident · Minor injuriesFinal reportPiper PA 36-300 · Mingo, KSInadequate airspeed resulting in a stall/mush being encountered by the PIC. Contributing factors were a tailwind and a load jettison not performed.NTSB ANC90LA162Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Alagnak River, AKThe pilot-in-command's inadequate preflight planning/preparation, his selection of unsuitable terrain, and his delay in aborting the takeoff.NTSB ANC90LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Northway, AKThe pilot-in-command's failure to maintain aircraft control.NTSB NYC90LA206Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Palmyra, NYPilot's failure to maintain airspeed during approach resulting in the airplane stalling and descending uncontrolled to ground impact.NTSB NYC90LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Reading, PAA loss of engine power for unknown reasons and an off airport landing on unsuitable terrain.NTSB NYC90DFJ04Accident · No injuriesFinal reportSchweizer Grumman G-164A · Wayland, NYA cracked engine cylinder assembly, which resulted in loss of engine power.