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 ATL91LA136Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Belhaven, NCThe poor in flight planning by the pilot. Factors related to the accident were the failure of the pilot to compensate for the tail wind, maintain airspeed, and maintain clearance from the trees.Jul 20, 1991 · N51361 · Substantial damageNTSB ATL91LA130Accident · 1 fatalLimited investigationFinal reportCessna 188 · Snow Hill, NCInadequate visual lookout by the pilot. Factors to the accident were tree.Jul 20, 1991 · N9072R · DestroyedNTSB ATL91FA138Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Mobile, ALThe failure of the pilot to maintain airspeed and his subsequent inadvertent stall during his attempt to return to the departure runway. A factor was the loss of engine power for undetermined reasons.Jul 20, 1991 · N96802 · DestroyedNTSB SEA91FA181Accident · 2 fatalField investigationFinal reportCessna 180J · Newcastle, WYPilot factor in that he did not maintain sufficient flying speed and allowed the aircraft to enter an inadvertent stall/spin. Factors include high density altitude.Jul 19, 1991 · N9962N · DestroyedNTSB NYC91DNC03Accident · 1 fatalFinal reportValentin GMB H Taifun 17E · West Arlington, VTPhysiological incapacitation due to cardiovascular disease which resulted in incapacitation and inflight collision with trees.Jul 19, 1991 · N333VT · DestroyedNTSB LAX91LA319Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Patterson, CAThe pilot-in-command's improper visual lookout in a descent at low altitude, resulting in an in flight collision with wires and subsequent in flight collision with terrain.Jul 19, 1991 · N23142 · Substantial damageNTSB LAX91LA318Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Chico, CAThe pilot's improper starting procedure.Jul 19, 1991 · N6387E · DestroyedNTSB FTW91DPG16Accident · No injuriesFinal reportAyres S2R-T34 · Mellwood, ARFailure of the pilot to maintain proper clearance with the power line.Jul 19, 1991 · N3092S · Substantial damageNTSB FTW91DPG15Accident · No injuriesFinal reportGrumman 164B · Brinkley, ARA blocked fuel screen which resulted in a fuel starvation induced loss of power. A factor was the lack of suitable terrain for the forced landing.Jul 19, 1991 · N8491K · DestroyedNTSB CHI91DTK03Accident · 1 fatalFinal reportWag-Aero Super Cuby · Roscoe, SDThe pilot's inadvertent stall and inadequate remedial action. Associated factors are the pilot's lack of recent total experience and inadequate preflight planning/preparation.Jul 19, 1991 · N336DT · DestroyedNTSB CHI91DTG05Accident · No injuriesFinal reportCessna T188C · Bathgate, NDA loss of control inflight which resulted in a collision with the crop.Jul 19, 1991 · N2056J · Substantial damageNTSB CHI91DCQ07Accident · No injuriesFinal reportGrumman G-164A · Sharon Springs, KSAircraft takeoff performance exceeded and disregard of performance data by the pilot. A factor associated with the accident is high density altitude.Jul 19, 1991 · N7964 · Substantial damageNTSB ANC91LA103Accident · No injuriesLimited investigationFinal reportCessna 185 · Jago River, AKThe pilot's loss of directional control of the airplane during the landing roll. Contributing to the accident was the wet surface of the airstrip, the curve in the airstrip, and the vegetation which covered the entire airstrip.Jul 19, 1991 · N1650Z · Substantial damageNTSB SEA91LA179Accident · No injuriesLimited investigationFinal reportCessna 188B · Palouse, WAThe pilot's failure to maintain proper runway alignment.Jul 18, 1991 · N731YZ · Substantial damageNTSB SEA91LA178Accident · No injuriesLimited investigationFinal reportGrumman G-164-B · Pullman, WAThe pilot's failure to maintain runway alignment. Factors include high vegetation growing close to the runway.Jul 18, 1991 · N6657Q · Substantial damageNTSB SEA91LA176Accident · No injuriesLimited investigationFinal reportMooney M-20K · Mccall, IDAn on ground collision with an animal during the landing roll. A factor to the accident was: a dark night condition.Jul 18, 1991 · N231AS · Substantial damageNTSB NYC91LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln Park, NJThe decision of the pilot to discontinue a go-around, from an attempted landing, resulting in the airplane striking trees. A factor related to the accident was the lack of total flight experience of the student pilot.Jul 18, 1991 · N737WG · Substantial damageNTSB MIA91LA202Accident · No injuriesLimited investigationFinal reportCessna A188B · Hollandale, MSOverload failure of the no. 5 cylinder connecting rod bolt due to being loose for undetermined reasons. This resulted in the damage during the forced landing following total loss of engine power.Jul 18, 1991 · N9541J · Substantial damageNTSB LAX91LA316Accident · 2 fatalLimited investigationFinal reportJurca MJ5 Sirocco · Lake Mathews, CAThe pilot's intentional low altitude flight which resulted in a collision with a power line static cable. Contributing to the accident was inadequate light conditions which reduced the pilot's ability to detect the power line.Jul 18, 1991 · N239GA · DestroyedNTSB FTW91FA124Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Whitharral, TXPower loss due to fuel exhaustion. Factors were the pilot's operation with the known inoperative landing light and the dark night.Jul 18, 1991 · N9326T · DestroyedNTSB FTW91FA123Accident · 1 fatalField investigationFinal reportHughes 269B · Brickeys, ARThe failure of the clutch control cable due to fraying which initiated the forced landing and the operator's failure to perform recommended inspections on the aircraft. Factors were the pilot's failure to maintain rotor RPM and the unsuitable terrain.Jul 18, 1991 · N11XC · DestroyedNTSB CHI91DEV02Accident · No injuriesFinal reportO'Connell Stits SA-3B · Casey, ILThe pilot's failure to maintain a proper rate of climb after takeoff. A factor in the accident was the pilot's lack of experience in model.Jul 18, 1991 · N2821 · Substantial damageNTSB SEA91LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Walla Walla, WAThe student pilot's poor compensation for wind conditions. Factors were downdrafts and the student pilots lack of experience in this type of operation.Jul 17, 1991 · N48965 · Substantial damageNTSB SEA91FA175Accident · 1 fatalField investigationFinal reportCessna TU206G · Mccall, IDProcedures/directives were not followed. Factors to the accident were: improper fuel boost pump selector position, leaded spark plugs and sunglare.Jul 17, 1991 · N7216N · DestroyedNTSB NYC91LA225Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103B · Marion, OHThe pilot's improper decision to change landing runways with insufficient altitude and airspeed which resulted in a dragged wing and ground loop.Jul 17, 1991 · N5448X · Substantial damageNTSB NYC91LA186Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbus, OHThe failure of the pilot to maintain an adequate visual lookout which resulted in a ground collision with a parked aircraft. Factors related to the accident was the failure of the pilot to taxi on the taxiway centerline and night conditions.Jul 17, 1991 · N738VP · Substantial damageNTSB NYC91LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Springwater, NYThe on ground collision with trees during a forced landing after the pilot experienced an engine failure due to a broken exhaust valve.Jul 17, 1991 · N6489B · DestroyedNTSB MIA91LA188Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Cleveland, MSInadequate preflight resulting in water contamination causing loss of engine power.Jul 17, 1991 · N9327R · DestroyedNTSB MIA91LA187Accident · Minor injuriesLimited investigationFinal reportBeech 65 · Meridian, MSLoss of power from the right engine due to undetermined reasons. The failure of the propeller to feather was a factor in the accident.Jul 17, 1991 · N711SF · DestroyedNTSB LAX91LA317Accident · No injuriesLimited investigationFinal reportBeech 55B · Cupertino, CAFuel exhaustion which resulted from the pilot inaccurately calculating fuel consumption and fuel requirements.Jul 17, 1991 · N54339 · Substantial damageNTSB LAX91LA315Accident · 2 fatalLimited investigationFinal reportPiper PA32-300 · Corona, CAThe pilot's failure to maintain an airspeed above the aircraft's stall speed after the engine failed. Factors contributing to the accident were: the failure of the engine, magneto and accessory drive gear, the rough terrain conditions over which the engine…Jul 17, 1991 · N5233S · Substantial damageNTSB DEN91LA101Accident · No injuriesLimited investigationFinal reportCessna 421B · Colorado Spring, COA fractured fuel line and an improperly performed annual inspection.Jul 17, 1991 · N768RA · Substantial damageNTSB CHI91MA220Accident · No injuriesMajor investigationFinal reportAerospace ATR-42-300 · Peoria, ILInadequate aircraft equipment component (failed bolt), and insufficient inspection standards pertaining to the failed bolt. A factor related to the accident is inaccurate maintenance record keeping relating to oil consumption.Jul 17, 1991 · N425TE · Substantial damageNTSB CHI91DTG04Accident · No injuriesFinal reportCessna T188C · Walhalla, NDInadequate compensation for wind conditions, and failure to maintain directional control. Factors related to the accident are gusty crosswind conditions.Jul 17, 1991 · N2093J · Substantial damageNTSB ATL91IA134Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Savannah, GAThe inadequate inspection procedures which allowed the loss of torque on the top retraction fitting attachment bolt which subsequently failed in fatigue. Factors were the loss of hydraulic fluid through a severed line, and the corrosion of a hydraulic…Jul 17, 1991 · N922HA · Minor damageNTSB ANC91LA101Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Chataniak Vly, AKPartial loss of engine power for an undetermined reason.Jul 17, 1991 · N84903 · Substantial damageNTSB NYC91LA137Accident · No injuriesLimited investigationFinal reportBeech C-23 · Chesapeake, OHThe pilot's failure to maintain an adequate airspeed that would preclude a stall. Contributing to the accident was the opened door.Jul 16, 1991 · N9723Q · Substantial damageNTSB CHI91LA219Accident · No injuriesLimited investigationFinal reportSchweizer 2-32 · Plainfield, ILPilot's failure to attain proper alignment with the runway. A factor related to the accident was the high vegetation/crop in which the landing was made.Jul 16, 1991 · N2477W · Substantial damageNTSB ATL91LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Springfield, TNThe PA-24 pilot's failure to maintain proper airspeed while executing a go-around, resulting in the stalling of the airplane. A factor in the accident was the PA-24 pilot's failure to visually detect the J-3 in a timely manner.Jul 16, 1991 · N8739P · Substantial damageNTSB ANC91LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Naknek, AKThe pilot misjudged the proper touchdown. Contributing to the accident was the gust of wind on final approach.Jul 16, 1991 · N2120M · Substantial damageNTSB ANC91IA102Incident · No injuriesIncident investigationFinal reportDe Havilland DHC2 MK1 · Iliamna, AKThe pilot-in-command's attempted flight into known adverse weather conditions. Contributing to the accident was the high and gusty winds in the accident area.Jul 16, 1991 · N6LU · Minor damageNTSB SEA91LA174Accident · No injuriesLimited investigationFinal reportSchrader, Edward A · Nampa, IDA loss of engine power for undetermined reasons.Jul 15, 1991 · N62KS · Substantial damageNTSB LAX91LA314Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · So. Lake Tahoe, CAEngine failue due to the failure of the crankshaft resulting from failure induced by a non-metallic inclusion in the shaft.Jul 15, 1991 · N646RL · Substantial damageNTSB LAX91LA313Accident · No injuriesLimited investigationFinal reportRockwell 500S · Kahului, HIThe pilot's inadequate preflight inspection of the aircraft after refueling. The failure of the aircraft manufacturer to publish the refueling instructions in the operator's manual, the inadequate fuel servicing of the aircraft by other maintenance personnel…Jul 15, 1991 · N260AC · Substantial damageNTSB FTW91DPG14Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARPartial failure of the hopper, chemical fire, and the failure of the landing gear. A factor ws the loss of visual outside reference.Jul 15, 1991 · N6615 · DestroyedNTSB ATL91LA133Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Hawkinsville, GAThe pilot's inadequate preflight planning, his failure to refuel the airplane when he observed his fuel supply getting low, and the resultant exhaustion of his fuel supply.Jul 15, 1991 · N4800P · Substantial damageNTSB SEA91LA169Accident · Minor injuriesLimited investigationFinal reportBeech B19 · Bend, ORPoor preflight planning/preparation by the pilot in command. Factors to the accident were: high density altitude, excessive climb rate, inadequate remedial action, and lack of total flight expereince.Jul 14, 1991 · N24576 · Substantial damageNTSB SEA91FA170Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Driggs, IDThe pilot's poor inflight decision and his improper compensation for wind. Factors were rising, mountainous terrain; high, gusty winds; and a high density altitude.Jul 14, 1991 · N501FL · DestroyedNTSB NYC91LA181Accident · No injuriesLimited investigationFinal reportErcoupe 415D · Sacramento, KYThe pilot's decision to conduct flight with a known deficiency that adversely affected the aerodynamic characteristics of the aircraft.Jul 14, 1991 · N980DD · DestroyedNTSB NYC91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Old Bridge, NJThe failure of both pilots to maintain proper visual lookout. Factor related to the accident was inadequate radio communications by the pilots.Jul 14, 1991 · N7191W · 2 aircraft · Substantial damage