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 NYC92LA008Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Townshend, VTThe pilot allowed the speed of the airplane to get too slow, resulting in inadvertent stall at too low an altitude to allow recovery.Oct 14, 1991 · N5014M · Substantial damageNTSB LAX92LA014Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350D · Hilo, HI1) A loss of engine power due to the ingestion of gasses from the active volcano vent, and 2) the pilots inflight decision to hover downwind in close proximity to the vent.Oct 14, 1991 · N35961 · Substantial damageNTSB FTW92LA008Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31 · Big Spring, TXThe complete loss of engine power due to a failed piston rod. A factor was the lack of suitable terrain for the forced landing.Oct 14, 1991 · N9755E · Substantial damageNTSB CHI92LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-46-310P · Sioux Center, IAThe pilot in command's not maintaining directional control and not performing an aborted takeoff. Windshear was a factor relating to the accident.Oct 14, 1991 · N1FY · Substantial damageNTSB CHI92FA009Accident · 2 fatalField investigationFinal reportBeech A36 · Lakeville, MNThe pilot-in-command's decision to continue flight into known adverse weather. Contributing to the accident was the encounter with weather conditions favorable for formation of airframe icing.Oct 14, 1991 · N46MJ · DestroyedNTSB ATL92LA007Accident · No injuriesLimited investigationFinal reportKaman HH-43B/F · Mt. Vernon, ALA loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing site.Oct 14, 1991 · N55714 · Substantial damageNTSB ATL92LA006Accident · No injuriesLimited investigationFinal reportGrumman G164 · Bay Minette, ALThe rough/uneven runway condition caused by the sink hole.Oct 14, 1991 · N590Y · Substantial damageNTSB ANC92LA009Accident · No injuriesLimited investigationFinal reportCessna 180 · Berners Bay, AKThe pilot's loss of control during the pre takeoff taxi, due to his improper handling of the airplane. Contributing to the accident was the soft takeoff area.Oct 14, 1991 · N4693B · Substantial damageNTSB SEA92LA010Accident · No injuriesLimited investigationFinal reportCessna 172C · Colville, WAThe pilot's delayed go-around. Factors contributing to the accident was the pilot's misjudgement of distance and speed during the approach.Oct 13, 1991 · N64475 · Substantial damageNTSB NYC92LA007Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Boxboro, MAThe pilot's failure to perform an adequate preflight to remove ice/frost from the aircraft wings.Oct 13, 1991 · N26697 · Substantial damageNTSB NYC92DNC01Accident · No injuriesFinal reportDenney Aircraft Behn KIT FOX III · Hartford, VTAn inadvertent stall/spin. Factors related to the accident were an improperly planned approach by the pilot, the failure of the pilot to attain and maintain flying speed, rising terrain, and turbulent air conditions.Oct 13, 1991 · N898KG · Substantial damageNTSB NYC92DHJ01Accident · 1 fatalFinal reportChallenger II Bombadier · Moriches, NYA loss of control in flight due to a flight control malfunction for undetermined reasons.Oct 13, 1991 · N8182K · DestroyedNTSB MIA92LA014Accident · No injuriesLimited investigationFinal reportBell 47G-5 · La Belle, FLThe pilot in command's improper aft application of cyclic control during an autorotative landing to an open field, resulting in the main rotor blades colliding with the tail boom. Contributing to the accident was the in flight failure of the outer bearing of…Oct 13, 1991 · N1201W · Substantial damageNTSB MIA92LA013Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Sebring, FLFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and collision with tall grass beside the runway. The tall grass was a related factor.Oct 13, 1991 · N69SZ · Substantial damageNTSB DEN92LA003Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Telluride, COThe pilot flying the aircraft at a height above ground level which was inadequate for recovery from an encounter with down drafts. A factor was: down draft encounter.Oct 13, 1991 · N4488Z · Substantial damageNTSB ATL92LA005Accident · No injuriesLimited investigationFinal reportCessna 182 · Pinson, ALThe failure of the pilot to visually detect and attain proper alignment with the runway.Oct 13, 1991 · N9342X · Substantial damageNTSB SEA92LA005Accident · No injuriesLimited investigationFinal reportHughes 269B · Hillsboro, ORThe failure to maintain rotor RPM. Factors include inadequate preflight planning, overconfidence in aircraft's ability, and non-suitable terrain.Oct 12, 1991 · N9474F · Substantial damageNTSB NYC92LA006Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Catawissa, PAPilot factor in that the pilot used poor judgement and loaded more passengers than were seats on the helicopter this resulted in control interference and subsequent loss of control. Contributing was the pilot's failure to check the weight and balance for the…Oct 12, 1991 · N5NH · Substantial damageNTSB NYC92LA005Accident · 1 fatalLimited investigationFinal reportAerospatiale ATR-42-320 · Bridgeport, CTThe employee's failure to follow proper procedures and the diversion of her attention which resulted in her being struck by a spinning propeller.Oct 12, 1991 · N25811 · Minor damageNTSB MIA92RA011Incident · No injuriesForeign investigationBoeing 737-300 · Grand Cayman Is, Cayman IslandsOct 12, 1991 · VRCCWNTSB LAX92LA013Accident · No injuriesLimited investigationFinal reportStinson 108-8 · Susanville, CAAn inadvertent stall due to the failure of the pilot to maintain a correct airspeed during the approach.Oct 12, 1991 · N87607 · Substantial damageNTSB SEA92LA011Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Hyder, AKThe failure of the tail rotor hub assembly. Factors include unsuitable terrain, and high vegetation.Oct 11, 1991 · CGKHR · Substantial damageNTSB SEA92LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Rawlins, WYAn inadequate weather evaluation. Factors to the accident were: gusts and crosswind.Oct 11, 1991 · N2015B · Substantial damageNTSB MIA92FA012Accident · 1 fatalField investigationFinal reportCessna 177 · Green Cove Spgs, FLThe pilot in command's failure to maintain a visual lookout.Oct 11, 1991 · N3288T · 2 aircraft · Minor damageNTSB LAX92LA012Accident · No injuriesLimited investigationFinal reportBeech K35 · Grass Valley, CAThe inadvertent encounter with a microburst/downburst phenomena associated with thunderstorm activity. A factor in the accident was the failure of the pilot to adequately assess the weather conditions during the landing attempt.Oct 11, 1991 · N9559R · Substantial damageNTSB FTW92LA007Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Palacios, TXThe pilot's inadequate preflight.Oct 11, 1991 · N4029D · Substantial damageNTSB FTW92IA009Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 3100 · Dfw Int'L Arpt, TXThe partial disconnection of the electrical connector at the torque sensing unit.Oct 11, 1991 · N425AE · No damageNTSB ATL92LA004Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Franklin, NCThe pilot's failure to lower the landing gear resulting in a gear up contact with the runway, and the eventual loss of control of the airplane.Oct 11, 1991 · N37MC · Substantial damageNTSB ANC92LA004Accident · No injuriesLimited investigationFinal reportCessna 170B · Chugiak, AKThe student pilot's failure to maintain directional control during the takeoff run.Oct 11, 1991 · N4606C · Substantial damageNTSB SEA92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Renton, WAA loss of engine power for undetermined reasons and unsuitable terrain available for a forced landing.Oct 10, 1991 · N55841 · Substantial damageNTSB NYC92LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Toledo, OHThe pilot's failure to preform an aircraft preflight, and remove the gust lock from the aileron, resulting in a loss of airplane control during initial climb.Oct 10, 1991 · N739LT · Substantial damageNTSB MIA92LA009Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Panama City, FLLoss of power due to undetermined reasons. Contributing to the accident was the cfi's inadequate emergency procedures following the reported loss of power.Oct 10, 1991 · N25PA · Substantial damageNTSB FTW92DPJ02Accident · 1 fatalFinal reportPiper PA-25 · Warner, OKThe complete loss of engine power for undetermined reason.Oct 10, 1991 · N8516L · DestroyedNTSB CHI92LA006Accident · No injuriesLimited investigationFinal reportCessna 421B · Battle Creek, MIThe total failure of the right main landing gear's downlock link assembly.Oct 10, 1991 · N100CA · Substantial damageNTSB CHI92LA005Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Cassville, MOThe pilot-in-command's improper preflight planning and preparation. Factors contributing to this accident were fuel exhaustion, a hidden obstruction within the terrain the pilot landed on and a collapsed nosegear.Oct 10, 1991 · N2563J · Substantial damageNTSB NYC92LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Lincoln, METhe pilot's failure to see and avoid the transmission lines. A factor was the sunglare.Oct 9, 1991 · N76101 · Substantial damageNTSB LAX92LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe student pilot's improper landing flare which resulted in a hard landing and the buckling of the airplane's nose gear.Oct 9, 1991 · N6211Q · Substantial damageNTSB FTW92LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane prior to the flight. A factor was the fbo's failure to properly maintain the fuel quantity gauges.Oct 9, 1991 · N5399B · Substantial damageNTSB CHI92LA004Accident · No injuriesLimited investigationFinal reportBeech 95 · Elkhart, INThe inadequate amount of hydraulic fluid present in the normal brake system.Oct 9, 1991 · N1309Z · Substantial damageNTSB ANC92TF#01Accident · No injuriesClass 3Final reportPiper PA-18 · Port Heiden, AKOct 9, 1991 · N7056 · Substantial damageNTSB SEA92LA015Accident · No injuriesLimited investigationFinal reportCessna 177A · Trout Lake, WAAn inadequate compensation for wind, and proper climb rate not being maintained. Factors include inadequate preflight planning, the pilot's over-confidence in his own ability and the ability of the aircraft, lack of experience in this type of operation, and a…Oct 8, 1991 · N30515 · Substantial damageNTSB SEA92LA003Accident · No injuriesLimited investigationFinal reportCessna 337A-RG · Snohomish, WAFuel system starvation, due to the pilot's improper fuel tank selection. Factors include procedures not being followed, and inattentiveness.Oct 8, 1991 · N6396F · Substantial damageNTSB MIA92FA008Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Key West, FLFailure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin at an altitude that was too low for recovery. A factor related to the accident was: the pilot's failure to jettison the banner when the stall was encountered.Oct 8, 1991 · N4155Y · Substantial damageNTSB CHI92LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Marion, WIThe failure of the exhaust and intake valves. Factors contributing to the accident were downhill terrain and a collapsed nosegear.Oct 8, 1991 · N704CW · Substantial damageNTSB NYC92LA002Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227AC · Augusta, METhe copilot's failure to attain a proper touchdown point. Factors were the captain's failure to follow company procedure and both pilot's limited experience.Oct 7, 1991 · N120FA · Substantial damageNTSB MIA92LA007Accident · Minor injuriesLimited investigationFinal reportO'Dell, Herbert L. Evans VP-1 · Summerfield, FLTotal loss of engine power due to fuel exhaustion and inadequate preflight by the pilot-in-command.Oct 7, 1991 · N4224C · Substantial damageNTSB LAX92LA010Accident · No injuriesLimited investigationFinal reportHill RL Breezy · Buckeye, AZA loss of engine power for undetermined reasons.Oct 7, 1991 · N187JH · Substantial damageNTSB CHI92LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Roscoe, ILOperation of an aircraft with known deficiencies and deterioration/failure of the magneto(s). Factors related to the accident were: the lack of an annual inspection and non-compliance with an airworthiness directive (AD).Oct 7, 1991 · N2499M · Substantial damageNTSB SEA92FA002Accident · 4 fatalField investigationFinal reportCessna 172G · Miltonfreewater, ORInadequate in-flight planning. Factors to the accident were: mountainous terrain, clearance not maintained, lack of total flight experience, and lack of familiarity with geographical area.Oct 6, 1991 · N1372F · DestroyedNTSB MIA92LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tylertown, MSOil fouling of the windshield due to a loose engine oil seal. A factor was the pilot's preexisting vision impairment.Oct 6, 1991 · N5414S · Substantial damage