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 MIA93LA077Accident · No injuriesLimited investigationFinal reportBeech N35 · Fort Meade, FLThe collision with a road sign during a forced landing. Contributing to the accident was the total loss of engine power due to fatigue failure of the crankshaft.Feb 28, 1993 · N1354Z · Substantial damageNTSB MIA93LA076Accident · Minor injuriesLimited investigationFinal reportHuddleston-Bell 47G2 · Rio Grande, PRPoor in-flight planning by the pilot-in-command. Contributing to the accident was the flight's lack of total experience.Feb 28, 1993 · N37870 · Substantial damageNTSB FTW93FA092Accident · 2 fatalField investigationFinal reportCessna 340A · Center Point, TXInadvertent stall. Factors were the weather and the light conditionsFeb 28, 1993 · N88KH · DestroyedNTSB DEN93LA028Accident · No injuriesLimited investigationFinal reportMaule M-5-220C · Englewood, COFailure by the pilot to maintain control of the aircraft. A factor was: lack of experience in type of aircraft.Feb 28, 1993 · N16CB · Substantial damageNTSB CHI93LA195Accident · No injuriesLimited investigationFinal reportCessna A150L · Blaine, MNThe failure of the pilot of the Cessna 150, N6059J, and the pilot of the challenger to see and avoid each other.Feb 28, 1993 · N6059J · 2 aircraft · Minor damageNTSB CHI93LA100Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Mason City, IAExcessive braking by the dual student.Feb 28, 1993 · N2611K · Substantial damageNTSB CHI93LA099Accident · No injuriesLimited investigationFinal reportCessna 150M · Stanley, NDThe student pilot's delayed use of carburetor heat. The soft terrain in the landing area was a factor.Feb 28, 1993 · N704AF · Substantial damageNTSB BFO93LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Napoleon, OHThe intentional stall resulting in a hard landing. Contributing to the accident was the premature flare which led to an exceeded proper touchdown point and the student pilot's lack of overall experience.Feb 28, 1993 · N5220W · Substantial damageNTSB BFO93LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Boonville, NYThe pilot failed to compensate for wind conditions and encountered a stall. The windshear was a factor.Feb 28, 1993 · N1554P · Substantial damageNTSB ANC93LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Willow, AKThe abrupt aircraft handling by the pilot in command. Factors were the collapse of the nose gear and the soft, snow covered terrain.Feb 28, 1993 · N8076Z · Substantial damageNTSB SEA93LA069Accident · Minor injuriesLimited investigationFinal reportCessna T-210L · Ogden, UTThe loss on engine power from fuel exhaustion due to the inadequate preflt planning/preparation by the PIC and his failure to maintain proper airspeed during an emergency forced landing.Feb 27, 1993 · N2611S · Substantial damageNTSB MIA93LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Blountstown, FLInadequate visual lookout by the pilot resulting in failure to avoid the powerline.Feb 27, 1993 · N3064J · Substantial damageNTSB LAX93WA145Accident · 3 fatalForeign investigationPiper PA-28-235 · Loreto, MexicoFeb 27, 1993 · N166DP · DestroyedNTSB CHI93LA098Accident · No injuriesLimited investigationFinal reportCessna 172M · Grain Valley, MOThe student pilot's improper recovery from a bounced landing and failure to maintain directional control.Feb 27, 1993 · N64425 · Substantial damageNTSB BFO93LA043Accident · No injuriesLimited investigationFinal reportCessna 150 · Knoxville, PAThe pilot's failure to maintain directional control. Contributing to the accident was the pilot's failure to plow the runway adequately.Feb 27, 1993 · N8958S · Substantial damageNTSB BFO93LA035Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Xenia, OHLoss of partial power for undetermined reasons.Feb 27, 1993 · N63369 · Substantial damageNTSB BFO93FA034Accident · 1 fatalField investigationFinal reportCessna 180F · Brewer, MELoss of engine power due to undetermined reasons, and the failure of the pilot to maintain adequate airspeed during the forced landing which resulted in a stall.Feb 27, 1993 · N4607U · DestroyedNTSB ANC93LA037Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Egegik, AKThat the lift off airspeed was not attained by the pilot in command because of the snow covered runway.Feb 27, 1993 · N8257A · Substantial damageNTSB LAX93LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZLoss of engine power for an undetermined reason.Feb 26, 1993 · N975MA · Substantial damageNTSB CHI93LA112Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Brainerd, MNThe pilot's improper flare which resulted in a bounced, hard landing and the subsequent loss of directional control.Feb 26, 1993 · N44109 · Substantial damageNTSB SEA93LA067Accident · No injuriesLimited investigationFinal reportBeech C-99 · Seattle, WAThe improper starting procedure by the pilot of the Aeronca. A factor contributing to the accident was inadequate communications by the pilot of the Aeronca.Feb 25, 1993 · N63978 · Substantial damageNTSB CHI93LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marshfield, WIThe student pilot's failure to maintain aircraft directional control during the takeoff ground run.Feb 25, 1993 · N3044N · Substantial damageNTSB CHI93LA096Accident · No injuriesLimited investigationFinal reportCessna 172K · Jackson, MIThe pilot's failure to maintain directional control.Feb 25, 1993 · N46460 · Substantial damageNTSB CHI93LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Canton, MIThe student pilot's failure to maintain directional control.Feb 25, 1993 · N9297U · Substantial damageNTSB LAX93LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Santa Ana, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain an adequate approach reference airspeed. Factors in the accident were the pilot's low experience in the aircraft.Feb 24, 1993 · N43Y · Substantial damageNTSB LAX93LA136Accident · No injuriesLimited investigationFinal reportCessna T188C · Delhi, CAThe pilot selected unsuitable terrain for takeoff and failed to maintain directional control of the aircraft. A factor in the accident was the standing water on the runway.Feb 24, 1993 · N2086J · Substantial damageNTSB BFO93FA033Accident · 1 fatalField investigationFinal reportBeech E18S · Lemont, PAImproper inflight planning decision by the pilot, and his failure to maintain proper altitude during the approach. Factors related to the accident were darkness, adverse weather conditions, and high terrain.Feb 24, 1993 · N47E · DestroyedNTSB MIA93FA073Accident · No injuriesField investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLThe improper use of elevator flight control during the landing by the pilot in command.Feb 23, 1993 · N678DL · Substantial damageNTSB LAX93LA135Accident · Serious injuriesLimited investigationFinal reportDowner Aircraft Industries KR-1 · Prescott, AZThe total loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing area at the time of the power interruption.Feb 23, 1993 · N9HD · DestroyedNTSB LAX93LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Red Mountain, CAFuel exhaustion due to the pilot's inadequate preflight planning and his failure to refuel the aircraft. Factors in the accident were the pilot's inability to see the terrain due to the dark night conditions and the flight's encounter with instrument…Feb 23, 1993 · N5607P · Substantial damageNTSB FTW93LA090Accident · Minor injuriesLimited investigationFinal reportBell 206B · Oklahoma City, OKThe passengers inadvertent control interference. A factor was the pilot's inadequate supervision of the passengerFeb 23, 1993 · N224TV · Substantial damageNTSB CHI93LA094Accident · No injuriesLimited investigationFinal reportBeech B90 · Albert Lea, MNAn inadvertent stall due to ice in the pitot/static system.Feb 23, 1993 · N442TC · Substantial damageNTSB ANC93LA039Accident · No injuriesLimited investigationFinal reportCessna A185F · Fairbanks, AKThe fuel system selector valve being placed in the off position due to the improper installation of the fuel selector placard by an unqualified person. The snow covered forced landing area was a factor.Feb 23, 1993 · N37BC · Substantial damageNTSB MIA93LA072Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Raleigh, MSThe fatigue failure of the no. 1 exhaust valve for undetermined reasons, and the lack of suitable terrain for the forced landing.Feb 22, 1993 · N1581M · Substantial damageNTSB LAX93LA132Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe pilots failure to maintain an adequate visual lookout for obstructions while performing a low altitude surveillance operation in a mountainous area, and, his failure to select an altitude sufficient to ensure clearance from all potential obstacles.Feb 22, 1993 · N58240 · Substantial damageNTSB LAX93LA131Accident · Minor injuriesLimited investigationFinal reportSchicora Osprey 2 · Joshua Tree, CAThe failure of the pilot flying to attain adequate airspeed for lift off and the resulting inadvertent stall mush condition during the initial climb.Feb 22, 1993 · N186S · Substantial damageNTSB FTW93LA089Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Indian Village, LALanding performed short of the runway threshold. Factor was wet grassy terrainFeb 22, 1993 · N48455 · Substantial damageNTSB BFO93LA032Accident · 1 fatalLimited investigationFinal reportMorgan Challenger II · Quinton, VAThe pilot's impairment due to a neurological injury and drugs, and his failure to maintain control of the airplane during an approach to land. A factor related to the accident was the gusty wind condition.Feb 22, 1993 · UNREG · DestroyedNTSB CHI93LA092Accident · No injuriesLimited investigationFinal reportCessna 185F · Bridgeport, NEThe pilot's failure to maintain proper runway alignment during the landing roll.Feb 21, 1993 · N252W · Substantial damageNTSB MIA93LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe pilot-in-command's failure to maintain a visual lookout while taxiing into the parking area, resulting in an on-ground collision with a light pole.Feb 20, 1993 · N5394M · Substantial damageNTSB MIA93LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bunnell, FLThe rupture of the oil cooler line at the adel clamp for undetermined reasons, resulting in a loss of engine oil, and a subsequent engine seizure.Feb 20, 1993 · N55737 · Substantial damageNTSB LAX93LA129Accident · No injuriesLimited investigationFinal reportCessna 182R · Warner Springs, CAThe pilots decision to attempt flight into known adverse weather conditions.Feb 20, 1993 · N5514N · Substantial damageNTSB LAX93LA128Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Palo Alto, CAThe pilots inadequate compensation for the existing crosswind condition and his resultant loss of directional control.Feb 20, 1993 · N5506C · Substantial damageNTSB LAX93LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bakersfield, CAThe overload failure of the right main landing gear strut attach bolts due to a hard landing. The hard landing was the result of the student misjudging the landing flare, and, the inadequate supervision of the flight by the flight instructor.Feb 20, 1993 · N9750K · Substantial damageNTSB FTW93LA091Accident · No injuriesLimited investigationFinal reportCessna 150H · Adkins, TXThe student pilot's failure to maintain clearance while maneuvering. A factor was the student's diverted attention from the open engine inspection doorFeb 20, 1993 · N6623S · Substantial damageNTSB CHI93LA093Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Cannonball, NDThe blockage of the inlet air filter from snow.Feb 20, 1993 · N4229P · Substantial damageNTSB BFO93LA031Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Hudson, NYFailure of the pilot to maintain directional control, which resulted in an advertent ground swerve. The snowbank was a related factor.Feb 20, 1993 · N999HF · Substantial damageNTSB ANC93LA036Accident · No injuriesLimited investigationFinal reportMaule M5 · Chena Hot Sprng, AKThe total failure of the landing gear axle as a result of a pre existing fracture in the axle.Feb 20, 1993 · N9176E · Substantial damageNTSB ANC93LA035Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Bradley Lake, AKThe pilot in command not removing the frost from the plane's airfoil surfaces before takeoff and not aborting the takeoff when the airplane showed no sign of wanting to fly at the initial rotation point/airspeed. A factor in the accident was the icing…Feb 20, 1993 · N5036U · DestroyedNTSB ANC93FA034Accident · No injuriesField investigationFinal reportCessna 402C · Nome, AKThe pilot in command not removing the ice from the plane's airfoil surfaces before takeoff. The weather condition was a factor.Feb 20, 1993 · N4182G · Destroyed