NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
  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.

NTSB ANC90LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Canning River, AKThe engine power loss due to fuel contamination, and the lack of suitable terrain on which to land.Jul 9, 1990 · N8519Y · Substantial damageNTSB SEA90FA125Accident · Serious injuriesField investigationFinal reportCessna T210K · Everett, WAInadequate preflight by the pilot by not assuring that the rudder pedals were properly engaged. A factor related to the accident was: the pilot's lack of familiarity with this make and model of aircraft.Jul 8, 1990 · N9407M · DestroyedNTSB NYC90LA154Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Washington, PAThe pilot's failure to maintain clearance from objects while taxiing, and his visual lookout was inadequate.Jul 8, 1990 · N35551 · Substantial damageNTSB NYC90LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · High Point Lake, PAA loss of control upon touchdown and during the go around, which resulted in uncontrolled contact with the windsock and a rock quarry. Contributing was the excessive speed of the aircraft (reported 80 knots) upon initial touchdown.Jul 8, 1990 · N3776R · DestroyedNTSB LAX90LA247Accident · No injuriesLimited investigationFinal reportBeech A-35 · Santa Ynez, CAAn engine failure due to fuel leakage from a ruptured diaphram in the carburetor; failure of the aircraft owner to comply with the manufacturer's recommended component overhaul intervals.Jul 8, 1990 · N8663A · DestroyedNTSB LAX90LA245Accident · No injuriesLimited investigationFinal reportCessna 172 · Davis, CAThe pilot failed to maintin directional control by improperly using the brakes.Jul 8, 1990 · N7726X · Substantial damageNTSB FTW90LA134Accident · No injuriesLimited investigationFinal reportBeech BE-76 · Gainsville, TXFuel exhaustion due to inadequate planning by the pilot.Jul 8, 1990 · N2008A · Substantial damageNTSB FTW90GA137Accident · Minor injuriesFinal reportCessna 404 · San Angelo, TXImproper use of powerplant controls by the pilot-in-command (PIC). Factors related to the accident were: the pic's inadequate crew coordination, and the excessive airspeed and rate of descent that resulted, when the PIC maneuvered the aircraft back on course…Jul 8, 1990 · N6239G · Substantial damageNTSB FTW90DPJ09Accident · No injuriesFinal reportSchweizer SGS 2-33A · Norman, OKThe pilot's misjudgement of proper glidepath.Jul 8, 1990 · N65879 · Substantial damageNTSB CHI90DEM06Accident · Serious injuriesFinal reportFunk, D.D. B-85C · White Cloud, MIThe passengers disregard of the pilot's instructions and her failure to maintain clearance from the propeller.Jul 8, 1990 · N77721 · No damageNTSB ANC90LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dillingham, AKThe pilot's failure to maintain directional control during the landing roll.Jul 8, 1990 · N91248 · Substantial damageNTSB NYC90LA155Accident · No injuriesLimited investigationFinal reportCessna 305A · Newburyport, MAFailure of the pilot in command to follow procedures for landing with a banner still attached, contributing to the accident was the improper modification of banner release mechanism.Jul 7, 1990 · N5208G · Substantial damageNTSB NYC90LA152Accident · Minor injuriesLimited investigationFinal reportCessna C182A · Pepperell, MAInflight collision with terrain during a forced landing after the pilot experienced jammed flaps and a power loss due to the fuel selector being improperly positioned.Jul 7, 1990 · N5093D · Substantial damageNTSB LAX90LA246Accident · No injuriesLimited investigationFinal reportSchweizer 300C · San Jose, CAThe pilot's loss of directional control. A factor in the accident was his inadequate compensation for wind conditions.Jul 7, 1990 · N917JS · Substantial damageNTSB FTW90LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Wharton, TXThe loss of power due to an out-of-rig condition in the automatic auxiliary boost pump mechanism.Jul 7, 1990 · N351WB · Substantial damageNTSB FTW90FA138Accident · 1 fatalField investigationFinal reportMingess-Bennett M30 · New Braunfels, TXFailure of the pilot in the overtaking aircraft (N97RJ) to see-and-avoid the aircraft that had been leading (N911HG). Factors related to the accident were: the lack of ability for the pilot in the lead aircraft (911HG) to be able see other aircraft in the…Jul 7, 1990 · N97RJ · 2 aircraft · DestroyedNTSB DEN90LA152Accident · No injuriesLimited investigationFinal reportStinson 108 · Clovis, NMImproper installation of the right main wheel assembly.Jul 7, 1990 · N677C · Substantial damageNTSB CHI90LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Drummand Island, MIPilot-in-command's failure to plan his approach and landing to use all available runway. Contributing factors are inadequate preflight preparation, lack of familiarity with the destination airport, and inadequate runway markings.Jul 7, 1990 · N7636F · Substantial damageNTSB LAX90LA236Accident · No injuriesLimited investigationFinal reportCessna 172RG · Concord, CAThe student pilot's initiating an excessive descent and the cfi's inadequate remedial action.Jul 6, 1990 · N5388R · Substantial damageNTSB FTW90LA133Accident · 1 fatalLimited investigationFinal reportBell 206B · San Antonio, TXThe lineman/flight crewman not following procedures.Jul 6, 1990 · N3894L · No damageNTSB DEN90LA153Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Miles City, MTThe failure of the pilot to use carburetor heat during descent for landing, resulting in a loss of power.Jul 6, 1990 · N5665B · Substantial damageNTSB CHI90LA170Accident · No injuriesLimited investigationFinal reportCessna R182 · Lambertville, MIPilot in command's mis-placement of the airplanes landing gear lever in the 'up' position while the airplane was on the ground, thereby allowing the landing gear squat switch, located in the nose gear compartment, to function as a retracting controller during…Jul 6, 1990 · N757DG · Substantial damageNTSB CHI90DEP06Accident · 1 fatalFinal reportCessna 177B · Iola, WIFailure of the pilot to maintain adequate airspeed, which resulted in a stall/spin. Factors related to the accident were: the pilot's poorly planned approach, and his failure to go around.Jul 6, 1990 · N30666 · DestroyedNTSB SEA90LA124Accident · No injuriesLimited investigationFinal reportPiper J-2 · Concrete, WAThe pilot's improper planning/decisions and failure to maintain clearance from the trees.Jul 5, 1990 · N19236 · Substantial damageNTSB NYC90LA149Accident · No injuriesLimited investigationFinal reportBeech C23 · Allaire, NJThe pilot's improper flare for the landing.Jul 5, 1990 · N24630 · Substantial damageNTSB NYC90LA148Accident · No injuriesLimited investigationFinal reportCessna 150 · Montour Falls, NYThe pilot in command's decision to attempt takeoff at night from an inimproved field which resulted in collision with a vehicle.Jul 5, 1990 · N10267 · Substantial damageNTSB CHI90LA168Accident · No injuriesLimited investigationFinal reportBeech V35B · Lockport, ILThe pilot's failure to maintain aircraft directional control and keep the aircraft on the runway during the landing roll.Jul 5, 1990 · N35TP · Substantial damageNTSB ATL90LA140Accident · No injuriesLimited investigationFinal reportBeech C24R · Brunswick, NCEngine malfunction for undetermined reasons. A factor in the accident was the unseen ditch with which the airplane collided.Jul 5, 1990 · N2249L · Substantial damageNTSB ANC90LA112Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Coldfoot, AKThe airplane encountered a downdraft shortly after takeoff from which the airplane could not overcome with power. Contributing to the accident was the heavily loaded airplane and the engine not developing full power due to improper maintenance.Jul 5, 1990 · N6374J · DestroyedNTSB SEA90LA121Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Walla Walla, WAA loss of engine power for undetermined reasons.Jul 4, 1990 · N62431 · Substantial damageNTSB NYC90LA146Accident · No injuriesLimited investigationFinal reportde Havilland DH-82-A · Burlington, CTThe pilot's inadequate compensation for the wind condition.Jul 4, 1990 · N82DH · Substantial damageNTSB NYC90LA145Accident · No injuriesLimited investigationFinal reportCessna 177B · Danielson, CTThe failure of the pilot to maintain proper runway alignment, and his failure to obtain or maintain adequate airspeed during a go-around, which resulted in an inadvertent stall and collision with the shrubs and trees.Jul 4, 1990 · N35017 · Substantial damageNTSB LAX90FA244Accident · 1 fatalField investigationFinal reportCessna 172N · Avalon, CAThe pilot's improper in-flight planning, decision, and his intentional low flying near mountainous terrain. Contributing factors related to the pilot's not maintaining/following proper VFR procedures, the related distraction of the open cabin door, and the…Jul 4, 1990 · N2810E · DestroyedNTSB FTW90LA131Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · College Station, TXThe pic's improper fuel tank selection, allowing both engine to quit due to fuel starvation.Jul 4, 1990 · N7546Q · Substantial damageNTSB DEN90IA154Incident · No injuriesIncident investigationFinal reportAerospatiale A-300B4 · Denver, COEngine failure due to turbine wheel failure, induced by fatigue.Jul 4, 1990 · N72990 · Minor damageNTSB ANC90FA111Accident · No injuriesField investigationFinal reportCessna 170B · Anchorage, AKThe pilot-in-command's failure to maintain airspeed on initial climbout.Jul 4, 1990 · N3261A · Substantial damageNTSB SEA90LA123Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Worley, IDImproper planning/decision by the pilot, which resulted in an inadequate supply of fuel and fuel exhaustion. The high vegetation (wheat crop) and rough terrain (rut) were related factors.Jul 3, 1990 · N771C · Substantial damageNTSB SEA90LA120Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Island Park, IDPilot's failure to maintain directional control, while attempting a soft-field takeoff. The crosswind was a related factor.Jul 3, 1990 · N38575 · Substantial damageNTSB NYC90LA144Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider LS-3 · South Mountain, PAThe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall.Jul 3, 1990 · N41MP · Substantial damageNTSB LAX90LA243Accident · Minor injuriesLimited investigationFinal reportBeech 95-C55 · Fullerton, CAThe pilot's failure to detect an incorrect rudder trim adjustment, his failure to follow the prescribed pre-takeoff instructions that call for the trim to be adjusted. The collision with the fence and the incorrect rudder trim adjustment were factors in the…Jul 3, 1990 · N5852J · Substantial damageNTSB LAX90LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hickman, CAThe pilot's improper planning & decision, an inadequate fuel supply, and fuel exhaustion. A contributing factor was related to the false indication of the fuel quantity gages.Jul 3, 1990 · N25899 · Substantial damageNTSB FTW90LA132Accident · No injuriesLimited investigationFinal reportBeech B19 · Mc Kinney, TXInadequate supervision by the PIC, the instructor pilot, when he allowed the student pilot to flare at too high an altitude off the runway.Jul 3, 1990 · N18989 · Substantial damageNTSB CHI90LA167Accident · No injuriesLimited investigationFinal reportCessna 150G · Manchester, MILoss of engine power due to a stuck exhaust valve.Jul 3, 1990 · N4690X · Substantial damageNTSB CHI90DEI01Accident · No injuriesFinal reportChampion 7GCAA · Ashland, OHThe pilot's failure to adequately preflight the airplane prior to takeoff. Resulting in a fuel leak going undetected.Jul 3, 1990 · N8326V · Substantial damageNTSB ANC90LA113Accident · No injuriesLimited investigationFinal reportCessna 180B · Butterfly Lake, AKThe pilot failed to retract the airplane's wheel prior to a water landing. Contributing factors are his failure to follow established procedures/directives, and habit interference caused by his concern over an air traffic conflict during the preceding takeoff.Jul 3, 1990 · N3125W · Substantial damageNTSB ANC90LA110Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cantwell, AKThe pilot failed to understand the performance parameters of the airplane and his lack of total experience. A contributing factor to the accident was operating the airplane at a greater than allowable gross weight.Jul 3, 1990 · N25759 · Substantial damageNTSB ANC90LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKThe pilot inadvertently stalled the airplane.Jul 3, 1990 · N4878A · Substantial damageNTSB SEA90FA122Accident · 5 fatalField investigationFinal reportCessna T210L · Ashford, WAThe pilot's continuation of VFR flight into instrument meteorological conditions.Jul 2, 1990 · N59291 · DestroyedNTSB NYC90LA147Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Bedford, NYThe failure of the pilot to monitor the fuel gauges and fuel starvation. A factor related to the accident was the failure of maintenance personnel to detect the bent condition of the rear engine tank fuel selector control cable.Jul 2, 1990 · N337GB · Substantial damageNTSB MIA90IA148Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B · Tyndall Afb, FLA propeller blade fatigue failure due to improper overhaul by other maintenance personnel not performing overhaul in accordance with factory service bulletins.Jul 2, 1990 · N722DM · Minor damage