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 NYC90LA085Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Hudson, NYThe pilots improper operation of the flight controls which resulted in the loss of control of directional control of the airplane during a touch and go landing. Factors related to the accident were the pilot's lack of total experience.Apr 9, 1990 · N9741K · Substantial damageNTSB FTW90FA092Accident · 1 fatalField investigationFinal reportErcoupe 415CD · Hereford, TXInadvertent stall. Factors were maximum gross weight exceeded by the pilot, the pilot's impairment due to drugs, and the pilot's lack of total experience.Apr 9, 1990 · N3504H · DestroyedNTSB DEN90FA089Accident · 1 fatalField investigationFinal reportCessna 210E · Elbert, COThe pilot's initiation of flight into known adverse weather, the rapid ice accumulation on the airframe, and an inadvertent stall-mush, resulting in an uncontrolled descent into terrain.Apr 9, 1990 · N4912U · DestroyedNTSB ATL90LA094Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Stone Mountain, GAThe pilot's misjudged approach which resulted in a long, fast landing and subsequent overrun of the departure threshold. Factors in the accident were the pilot's failure to lower the flaps and establish a proper glidepath.Apr 9, 1990 · N74651 · Substantial damageNTSB ATL90FA095Accident · 2 fatalField investigationFinal reportEmbraer EMB-120 · Gadsden, ALInadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid oncoming traffic. A factor related to the accident was: the sun's glare, which restricted the vision of the Cessna 172 pilot.Apr 9, 1990 · N217AS · 2 aircraft · Substantial damageNTSB NYC90LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Bedford, MAFailure of the exhaust system and subsequent melting/shorting of the magneto p-leads.Apr 8, 1990 · N363CC · Substantial damageNTSB LAX90FA281Accident · 2 fatalField investigationFinal reportCessna 172E · Santa Paula, CAThe pilot's improper preflight planning and preparation and his delayed remedial action in executing a 180 degree turn. Contributing to this accident was the pilot's inadvertent encounter with weather conditions.Apr 8, 1990 · N39155 · DestroyedNTSB DEN90LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Forsyth, MTAn unexplained loss of engine power. A factor was the rough unsuitable terrain in which the forced landing was made.Apr 8, 1990 · N5628U · Substantial damageNTSB CHI90LA110Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Lodge, ILFailure of the pilot to maintain directional control during takeoff. The crosswind and the soft/uneven terrain were factors related to the accident.Apr 8, 1990 · N55JJ · Substantial damageNTSB CHI90LA109Accident · No injuriesLimited investigationFinal reportCessna 172P · Savanna, ILImproper planning/decision by the pilot. The strong/gusty crosswind was a related factor.Apr 8, 1990 · N89594 · Substantial damageNTSB BFO90LA034Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Lovingston, VAPilot failure to climb out of ground effect because of inadequate airspeed. Factor was unfavorable wind at takeoff.Apr 8, 1990 · N8874D · Substantial damageNTSB ANC90FA052Accident · No injuriesField investigationFinal reportAeronca 11AC · Chugiak, AKFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind and snow covered terrain beside the runway.Apr 8, 1990 · N86060 · Substantial damageNTSB ANC90FA051Accident · No injuriesField investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot lost directional control during the landing roll as a result of improper braking.Apr 8, 1990 · N64RS · Substantial damageNTSB MIA90FA102Accident · 1 fatalField investigationFinal reportFarrington AIR Command 532 · Okeechobee, FLPilot's decision to attempt to fly the gyrocopter without proper training resulting in the inflight loss of control and subsequent crash.Apr 7, 1990 · N532RC · DestroyedNTSB LAX90FA138Accident · 3 fatalField investigationFinal reportBeech A36 · Kneeland, CAThe pilot's improper use of IFR procedures by failing to maintain the minimum descent altitude for the segment of the approach that he was flying. The hilly/mountainous terrain was a related factor.Apr 7, 1990 · N3674B · DestroyedNTSB FTW90FA091Accident · 1 fatalField investigationFinal reportLuscombe 8-A · Baytown, TXThe pilot's inadvertent stall of the airplane while maneuvering after a partial power loss during initial climb and a partially blocked exhaust system which had been inadequately maintained.Apr 7, 1990 · N1410K · DestroyedNTSB FTW90DQA01Accident · 1 fatalFinal reportAir Command 532 · El Paso, TXFailure of the pilot to maintain aircraft control and rotor RPM. Factors related to the accident were: the pilot's lack of instruction and experience in rotorcraft.Apr 7, 1990 · UNREG · Substantial damageNTSB DEN90LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Ogallala, NEThe misjudged landing flare. A factor was the pilot's lack of experience.Apr 7, 1990 · N64739 · Substantial damageNTSB NYC90DFJ02Accident · 1 fatalFinal reportRobbins Breezy CG-1 · Horseheads, NYThe loss of aircraft control during high speed taxi for an unknown reason.Apr 6, 1990 · N68CG · DestroyedNTSB LAX90LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Concord, CAThe pilot in command to properly judge the timing of the landing flare.Apr 6, 1990 · N42599 · Substantial damageNTSB ANC90LA045Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA-315B · Trading Bay, AKThe pilot's inadvertent flight into instrument meteorological conditions (IMC). Factors related to the accident were: snow covered terrain, adverse weather conditions, and spatial disorientation of the pilot, due to lack of visual cure during the landing.Apr 6, 1990 · N37903 · Substantial damageNTSB SEA90LA063Accident · Serious injuriesLimited investigationFinal reportCessna 152II · Scio, ORAn inadequate recovery from a bounced landing and inadequate clearance to avoid colliding with trees.Apr 5, 1990 · N67749 · DestroyedNTSB SEA90LA062Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Hillsboro, ORPilot displayed poor starting procedures by proceeding with known deficiencies with the parking brake and the inadequacies of the tie down. The pilot did not attain assistance for this procedure which resulted in the airplane getting away and colliding with…Apr 5, 1990 · N9443K · Substantial damageNTSB SEA90LA061Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Boise, IDPilot did not maintain directional control of the airplane during the landing roll.Apr 5, 1990 · N97781 · Substantial damageNTSB MKC90LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hornersville, MOFailure of an engine cylinder.Apr 5, 1990 · N1015A · Substantial damageNTSB MIA90FA101Accident · 1 fatalField investigationFinal reportLockheed L-1049F · Levittown, PRFire of an undetermined origin that resulted in a loss of power in two engines during a three engine ferry flight. Factors related to the accident were: failure of the pilot to obtain the required authorization for the three engine ferry flight, and his…Apr 5, 1990 · HI515 · DestroyedNTSB CHI90LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · Franklin, WIInadequate compensation for wind conditions by the pilot, and his failure to maintain runway alignment during the attempted go-around (aborted landing). The wind conditions and soft terrain were related factors.Apr 5, 1990 · N3876J · Substantial damageNTSB CHI90FA108Accident · 1 fatalField investigationFinal reportBeech M35 · Romeo, MIA loss of control due to physical incapacitation (heart attack).Apr 5, 1990 · N9829R · DestroyedNTSB ATL90LA092Accident · No injuriesLimited investigationFinal reportBeech B35 · Brunswick, GAThe pilot's failure to properly manage his fuel supply by switching to a tank with fuel prior to the loss of engine power. Collision with the tree(s) was a factor related to the accident.Apr 5, 1990 · N5180C · Substantial damageNTSB MKC90LA080Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mounds, ARThe pilot's improper compensation for wind conditions. Factors related to the accident were: the pilot's selection of the wrong runway and the resultant tailwind condition.Apr 4, 1990 · N6556 · Substantial damageNTSB MIA90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Jackson, MSThe pilot's improper compensation for the cross-wind.Apr 4, 1990 · N2078B · Substantial damageNTSB LAX90LA137Accident · No injuriesLimited investigationFinal reportBell 47G · La Verne, CAThe helicopter's rotor system being allowed to underspeed as a result of improper use of flight controls by the dual student; improper supervision by the certified flight instructor; and delayed remedial action by the certified flight instructor which allowed…Apr 4, 1990 · N739B · Substantial damageNTSB LAX90FA135Accident · 1 fatalField investigationFinal reportGardner Pitts S-1 · Eloy, AZThe pilot delayed the recovery from the inverted flat spin maneuver and misjudged his altitude.Apr 4, 1990 · N104KF · DestroyedNTSB LAX90DVG04Accident · 1 fatalFinal reportGrumman G-164B · Esparto, CAThe pilot misjudged the airplane's clearance with the transmission wires.Apr 4, 1990 · N8011K · DestroyedNTSB FTW90DPA01Accident · No injuriesFinal reportGrumman G-164B · Bonham, TXA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Apr 4, 1990 · N48372 · Substantial damageNTSB DEN90LA086Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Morgan, UTSeparation of the tow rope and the pilot's failure to establish an appropriate descent rate as he returned to land. Contributing to the accident were the tailwind and the unsuitable terrain for landing beyond the runway end.Apr 4, 1990 · N2048T · Substantial damageNTSB MKC90LA079Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Des Arc, ARFailure of the engine fuel pump.Apr 3, 1990 · N4183X · Substantial damageNTSB MIA90TL#03Accident · Minor injuriesClass 3Final reportEnstrom F-28A · Ft Pierce, FLApr 3, 1990 · N9247 · Substantial damageNTSB LAX90LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Chino, CAFuel starvation due to the fuel tank outlets becoming unported as the aircraft maneuvered for landing. A factor was the pilot's preflight planning failed to insure that he had adequate fuel for the flight.Apr 3, 1990 · N9426K · Substantial damageNTSB FTW90LA090Accident · No injuriesLimited investigationFinal reportHughes H500C · Houston, TXThe total failure of the engine for undertemined reasons and the pilot misjudging the flare prior to touchdown.Apr 3, 1990 · N9128F · Substantial damageNTSB FTW90DRD04Accident · No injuriesFinal reportGrumman G-164B · Fenton, LAFailure of the elevator control rod end bearing.Apr 3, 1990 · N6714K · DestroyedNTSB FTW90DPJ04Accident · 1 fatalFinal reportMooney M20F · Bethany, OKLoss of control in flight when the pilot stalled and spun the airplane inadvertently while turning to the base leg. A factor was lack of night flying time.Apr 3, 1990 · N3514X · DestroyedNTSB CHI90IA106Incident · No injuriesIncident investigationFinal reportNihon YS-11A-600F · West Lafayette, INAn undetected accumulation of ice on the horizontal stabilizer. Relating factors were the manufacturer's lack of information and aircraft manuals relative to the understanding of, and appropriate procedures to prevent the loss of control.Apr 3, 1990 · N112MP · No damageNTSB CHI90DEP03Accident · No injuriesFinal reportJames A Nelson ZEN AIR CH701 · Raymond, WIManufacturer's inadequate design of the fuel drain. Contributing was the pilot-in-command's disregarding the fuel supply which resulted in fuel exhaustion.Apr 3, 1990 · N360JN · Substantial damageNTSB ATL90LA091Accident · No injuriesLimited investigationFinal reportPZL 80 · Wilmington, NCPilot's failure to properly adjust the throttle friction which resulted in the disconnection of the entire assembly.Apr 3, 1990 · N2246U · Substantial damageNTSB SEA90LA060Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-2 · Hillsboro, ORThe pilot's failure to refuel resulting in fuel exhaustion.Apr 2, 1990 · N9449J · Substantial damageNTSB SEA90FA071Accident · 1 fatalField investigationFinal reportNorth American Navion H · Enumclaw, WAPilot's inadequate preflight planning, and inadvertent flight into IMC conditions. Factors in the accident were the low ceiling and visibility weather conditions, the mountainous/hill terrain, the pilot's lack of instrument qualification and his lack of…Apr 2, 1990 · N285RM · DestroyedNTSB MKC90LA078Accident · Minor injuriesLimited investigationFinal reportCessna 310 · Belleville, KSThe pilot's inadequate remedial action in response to the loss of power in the right engine, which resulted in his failure to attain the proper touchdown point for landing.Apr 2, 1990 · N18HF · Substantial damageNTSB LAX90TL#01Accident · No injuriesClass 3Final reportGates Learjet 35 · Carlsbad, CAApr 2, 1990 · N51FN · Substantial damageNTSB LAX90LA134Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Cottonwood, AZThe failure to the pilot to maintain control of the aircraft. Contributing to the accident was the decision of the pilot to attempt a landing in a cross wind condition well beyond the capability of the aircraft.Apr 2, 1990 · N82805 · Substantial damage