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 LAX00FA160Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Grand Canyon, AZA snow ingestion caused loss of engine power due to the pilot's inadequate preflight inspection and failure to remove the accumulated snow from the engine inlet area. Also causal was the pilot's failure to maintain main rotor rpm while maneuvering to avoid…Apr 18, 2000 · N2267N · DestroyedNTSB DEN00FA074Accident · No injuriesField investigationFinal reportBell 206L-3 · Lakewood, COThe complete loss of the tail rotor blades due to a fatigue failure of one blade. Factors were sloping and rough uneven terrain for the ensuing forced landing.Apr 18, 2000 · N937S · Substantial damageNTSB DCA00WA042Incident · No injuriesForeign investigationBoeing 737-400 · Brisbane, AustraliaApr 18, 2000 · VHTJY · No damageNTSB CHI00LA115Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIthe student pilot's failure to maintain directional control of the airplane during the landing. Factors associated with the accident were the misjudged landing flare, the student's lack of total experience, the runway lights, and the runway signs.Apr 18, 2000 · N975BC · Substantial damageNTSB ANC00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot's excessive application of heel brakes. A factor associated with this accident was the pilot's lack of experience in the make and model of airplane.Apr 18, 2000 · N10100 · Substantial damageNTSB LAX00LA157Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Yreka, CAthe total loss of engine power while in cruise flight due to the fatigue failure of the engine's anti-ice bleed air line, which resulted in the pilot's inability to utilize the engine anti-ice system. Contributing factors were the icing conditions and the…Apr 17, 2000 · N1682U · Substantial damageNTSB LAX00GA158Accident · 3 fatalFinal reportGrumman US-2C · Reno, NVthe flying pilot's failure to maintain directional control following a loss of engine power. Also causal was the failure of the flight crew to follow the published checklist and use the rudder assist system, and the decision not to abort the takeoff.Apr 17, 2000 · N7046U · DestroyedNTSB LAX00FA159Accident · Serious injuriesField investigationFinal reportConvair BT-13A · Pearl Harbor, HIthe pilot's failure to anticipate turbulence from the formation lead airplane. Contributing to the accident was the pilot's failure to maintain control of the airplane.Apr 17, 2000 · N56336 · DestroyedNTSB IAD00FA038Accident · 1 fatalField investigationFinal reportPiper PA-12 · Norfolk, MAThe loss of power for undetermined reasons, which resulted in an inadvertent stall during at banner pick-up.Apr 17, 2000 · N3813M · Substantial damageNTSB FTW00RA128Accident · 7 fatalForeign investigationCessna TU206F · Nevaj, GuatemalaApr 17, 2000 · N59143NTSB SEA00FA074Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Babb, MTTerrain clearance was not maintained. High mountains, mountain obscuration, and the pilot's inadequate preflight planning/preparation were factors.Apr 16, 2000 · N284X · DestroyedNTSB MIA00LA136Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Immokalee, FLthe pilot misjudged the flare resulting in a hard landing short of the intended landing site, subsequently impacting the ground, and nosing over.Apr 16, 2000 · N238DM · Substantial damageNTSB MIA00LA135Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Athens, GAthe pilot's failure to maintain control of the helicopter resulting in his misjudging the flare and a subsequent hard landing. Factors in this accident were, the pilot's inadequate planned approach in trail of two heavier helicopters, a crosswind landing…Apr 16, 2000 · N992CH · Substantial damageNTSB LAX00LA156Accident · No injuriesLimited investigationFinal reportBell 407 · Grand Canyon, AZThe failure and subsequent disintegration of the oil cooler fan forward hanger bearing.Apr 16, 2000 · N175PA · Substantial damageNTSB IAD00LA037Accident · Minor injuriesLimited investigationFinal reportGreenleaf Exec 162F · Manassas, VAWas the pilot' use of an unsecured ballast weight in the cockpit that shifted in flight and blocked the collective control movement.Apr 16, 2000 · N162GG · Substantial damageNTSB FTW00LA124Accident · No injuriesLimited investigationFinal reportLuscombe 8C · Galveston, TXThe pilot's inadequate preflight inspection, which resulted in the pilot attempting to takeoff with the elevator and ailerons locked by the passenger side seatbelt.Apr 16, 2000 · N25270 · Substantial damageNTSB ANC00LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Delta Junction, AKThe pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, and snow-covered terrain.Apr 16, 2000 · N3697M · Substantial damageNTSB NYC00LA114Accident · No injuriesLimited investigationFinal reportLoomis Sidewinder · Cincinnati, OHA partial power loss for undetermined reasons.Apr 15, 2000 · N13545 · Substantial damageNTSB NYC00LA113Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Lanconia, NHThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall.Apr 15, 2000 · N42383 · Substantial damageNTSB MIA00LA143Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · Lakeland, FLthe pilot's improper inflight planning/decision to land long, with a tailwind, on a wet grass runway that resulted in the loss of control and the airplane exiting the runway, incurring substantial damage.Apr 15, 2000 · N930V · Substantial damageNTSB MIA00LA134Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Lakeland, FLThe disconnection of the tail rotor drive shaft and subsequent lack of tail rotor control. Contributing factors were the worn drive shaft splines and the pilots' failure to apply collective on the touchdown resulting in a hard landing and subsequent roll over.Apr 15, 2000 · N301CH · Substantial damageNTSB LAX00LA155Accident · Minor injuriesLimited investigationFinal reportSmith RV-4 · Willows, CADisconnection of the elevator push rod due to the owner/builder's improper installation of the rear jam nut on the elevator pushrod.Apr 15, 2000 · N63SM · Substantial damageNTSB FTW00RA126Accident · No injuriesForeign investigationLockheed L-1011-385 · Guayaquil, EcuadorApr 15, 2000 · N308GBNTSB FTW00LA125Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Arlington, TXThe failure of the pilot to maintain directional control during the landing roll. A factor was the pilot's total lack of experience in tailwheel airplanes.Apr 15, 2000 · N2868Z · Substantial damageNTSB CHI00LA114Accident · No injuriesLimited investigationFinal reportCessna 404 · Lansing, MIA loss of engine power due to improper fuel. Also causal was the improper aircraft service by the fixed base operator personnel and the unsuitable terrain for the forced landing encountered by the pilot. Factors were the improper grade of fuel and the lack of…Apr 15, 2000 · N26SA · Substantial damageNTSB CHI00LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Near Muskegon, MIthe pilot failed to maintain altitude after inadvertently flying to instrument meteorological conditions. Factors associated with the accident were the low ceilings and visibility, the pilot became disoriented after inadvertently flying into IMC, and the…Apr 15, 2000 · N560SP · Substantial damageNTSB CHI00LA112Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Kankakee, ILthe misjudged glidepath by the pilot. Factors were the failure of the impeller seal resulting in a total loss of engine oil and subsequent engine failure, the plowed farm field, and the lack of suitable terrain for the forced landing.Apr 15, 2000 · N82AW · DestroyedNTSB ATL00FA041Accident · 1 fatalField investigationFinal reportBeech BE-58 · Palatka, FLThe pilot's physically impaired condition due to his high level of alcohol. Factors were the pilot's intentional VFR flight into IMC conditions and failure to perform a missed approach, which resulted in a collision with the ground.Apr 15, 2000 · N1072D · DestroyedNTSB ANC00LA046Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Anchorage, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was a frozen puddle.Apr 15, 2000 · N88472 · Substantial damageNTSB SEA00LA073Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Acequia, IDThe pilot's failure to obtain/maintain adequate clearance with the irrigation system during initial climb. A contributing factor was the irrigation pivot.Apr 14, 2000 · N1524H · Substantial damageNTSB NYC00FA112Accident · 1 fatalField investigationFinal reportCessna 172H · Grottoes, VAThe pilot's loss of control of the airplane in instrument meteorological conditions, which resulted in an inadvertent stall/spin. Factors included the pilot's lack of instrument time under actual conditions, and his lack of recent instrument flight experience.Apr 14, 2000 · N1404F · DestroyedNTSB LAX00LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAThe loss of engine power for undetermined reasons during takeoff climb.Apr 14, 2000 · N81019 · Substantial damageNTSB CHI00FA111Accident · No injuriesField investigationFinal reportBell 222U · St. Paul, MNThe loss of clamp-up force between the transmission case and the pylon mounted actuator support assembly which resulted in fatigue failure of the threaded studs and dowel pins, the failure of the flight control system, helicopter control not being possible…Apr 14, 2000 · N225LL · Substantial damageNTSB ANC00LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Chickaloon, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were an open service door, and snow-covered terrain.Apr 14, 2000 · N6446K · Substantial damageNTSB SEA00LA071Accident · No injuriesLimited investigationFinal reportCessna 150H · Lopez Island, WAProper touchdown point not attained by the pilot. Factors include excessive speed at touchdown, a wet runway, a fence, and the pilot's inadvertent flight into IMC.Apr 13, 2000 · N50039 · Substantial damageNTSB MIA00LA133Accident · 1 fatalLimited investigationFinal reportAir & Space. 18A · Lakeland, FLThe pilot's in-flight loss of control while maneuvering for undetermined reasons resulting in an uncontrolled descent and subsequent in-flight collision with terrain.Apr 13, 2000 · N905AS · Substantial damageNTSB MIA00LA132Accident · Serious injuriesLimited investigationFinal reportHartline Glastar · Woodstock, ALa total engine failure for undetermined reason, resulting in a forced landing and subsequent impact with a tree.Apr 13, 2000 · N897G · Substantial damageNTSB MIA00LA131Accident · Minor injuriesLimited investigationFinal reportMcCan Velox REV II · Mulberry, FLThe bending overstress separation of the elevator pitch control rod for undetermined reasons. This resulted in an in-flight loss of control, bail out, and subsequent in-flight collision with terrain.Apr 13, 2000 · N103MV · DestroyedNTSB FTW00TA116Accident · Minor injuriesFinal reportHughes OH-6A · El Paso, TXThe failure of the pilot to maintain rotor rpm during an autorotation, which resulted in a hard landing. A factor was the partial loss of engine power resulting from the separation of the power control line due to fatigue, as a consequence of improper…Apr 13, 2000 · N6187Y · Substantial damageNTSB CHI00LA117Accident · No injuriesLimited investigationFinal reportCessna 172N · Chesterfield, MOthe pilot misjudged the landing flare which resulted in the airplane porpoising on the runway during the landing.Apr 13, 2000 · N5909E · Substantial damageNTSB ANC00LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Igiugig, AKThe pilot's intentional flight into known adverse weather. Factors associated with the accident were the variable crosswind conditions, and the pilot's inadequate compensation for those wind conditions.Apr 13, 2000 · N2790C · Substantial damageNTSB ANC00LA043Accident · No injuriesLimited investigationFinal reportCessna U206F · Delta Junction, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were snow-covered terrain, and a short runway/landing area.Apr 13, 2000 · N8255Q · Substantial damageNTSB SEA00LA070Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Auburn, WAThe pilot's failure to follow aircraft operating procedures by not raising the flaps during the go-around maneuver. Contributing factors were the pilot's failure to adhere to the balked landing checklist (FLAPS to 20) resulting in degraded climb performance,…Apr 12, 2000 · N9301U · Substantial damageNTSB MIA00LA130Accident · Minor injuriesLimited investigationFinal reportScott Vans RV-4 · Natchez, MSan inadvertent stall at too low altitude to allow recovery. Factors in this accident were fog and low ceilings.Apr 12, 2000 · N123SC · Substantial damageNTSB IAD00TA040Accident · No injuriesFinal reportCessna 182RG · Cleveland, OHthe pilot's intentional flight into known icing conditions which resulted in an inadvertent stall/mush and hard landing. A factor in the accident was the icing conditions.Apr 12, 2000 · N6183T · Substantial damageNTSB FTW00LA123Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Rocksprings, TXThe pilot's failure to maintain proper glidepath. A factor was the dark night light conditions.Apr 12, 2000 · N789CA · DestroyedNTSB DEN00LA073Accident · No injuriesLimited investigationFinal reportHelio H-295 · Albuquerque, NMThe flight instructor's failure to maintain aircraft control during takeoff initial climb.Apr 12, 2000 · N3MA · Substantial damageNTSB ANC00LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Aleknagik, AKThe first pilot's (pilot-in-command) inadequate evaluation of the weather, and failure to maintain an adequate altitude above the ground. Factors in the accident were low ceilings, and snow-covered terrain.Apr 12, 2000 · N6119W · Substantial damageNTSB SEA00LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe pilot's failure to attain proper alignment with the landing runway, and her failure to maintain proper glide path for the landing runway, resulting in an encounter with vortex turbulence from a preceding heavy aircraft landing on a parallel runway and…Apr 11, 2000 · N38GF · Substantial damageNTSB SEA00IA069Incident · No injuriesIncident investigationFinal reportCessna 182P · Tacoma, WAFlap attachment failure. Restricted movement of the aileron was a factor.Apr 11, 2000 · N1298M · Minor damage