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 MIA94LA071Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Port St. Lucie, FLThe failure of the pilot-in-command to properly preflight the airplane and ensure there was adequate fuel on board, and his improper in-flight planning/decision to continue the flight.Feb 12, 1994 · N89254 · Substantial damageNTSB LAX94LA141Accident · Serious injuriesLimited investigationFinal reportBoeing 747-400 · Pacific Ocean (Pacific Ocean)the failure of the chief steward to verify that all flight attendants had been informed, and were complying with the captain's instructions to remain seated with their seatbelts fastened.Feb 12, 1994 · N186UA · No damageNTSB LAX94LA123Accident · Minor injuriesLimited investigationFinal reportCessna 172K · New Cuyama, CAthe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control of the aircraft.Feb 12, 1994 · N7333G · Substantial damageNTSB LAX94LA122Accident · No injuriesLimited investigationFinal reportCessna 402C · Grand Canyon, AZThe failure of the other aircraft's left brake system due to a worn master cylinder, and the failure of the other pilot to taxi at a speed and spacing interval which would allow for successful remedial action.Feb 12, 1994 · N812AN · 2 aircraft · Substantial damageNTSB LAX94LA121Accident · No injuriesLimited investigationFinal reportGrumman AA-1A · Bishop, CAfuel exhaustion due to the pilot's inadequate preflight planning and en route fuel consumption monitoring.Feb 12, 1994 · N9614U · Substantial damageNTSB BFO94LA039Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Chittenango, NYThe pilot's inadequate planning/decision to take off with the presence of a tailwind.Feb 12, 1994 · N1626V · Substantial damageNTSB SEA94FA060Accident · 1 fatalField investigationFinal reportMooney M20K · Applegate, ORPoor in-flight planning/decision and icing conditions. Factors to the accident were: selected flight into known adverse weather, dark night, and mountainous terrain.Feb 11, 1994 · N1093M · Substantial damageNTSB CHI94LA085Accident · No injuriesLimited investigationFinal reportCessna 182P · Glen Ullin, NDThe delayed application of the carburetor heat by the pilot-in-command. The carburetor icing weather condition was a factor.Feb 11, 1994 · N1794M · Substantial damageNTSB CHI94FA082Accident · 2 fatalField investigationFinal reportCessna A185F · Sterling Hgts, MIThe pilot's impairment of judgment and performance due to alcohol, which led to his intentional buzzing, and his failure to maintain sufficient altitude (or clearance) from obstacles. Factors related to the accident were: darkness and the unlighted tower.Feb 11, 1994 · N53064 · DestroyedNTSB ATL94IA048Incident · Minor injuriesIncident investigationFinal reportBoeing DHC-8-102 · Charlotte, NCAn inflight encounter with turbulence, and the flight attendant's failure to fasten her seatbelt.Feb 11, 1994 · N882CC · No damageNTSB ANC94LA034Accident · No injuriesLimited investigationFinal reportCessna 206 · New Koliganek, AKThe pilot's failure to maintain control of the airplane. Factors in the accident were the strong crosswinds and the icy/snow covered taxi surface.Feb 11, 1994 · N60491 · Substantial damageNTSB SEA94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cheyenne, WYThe pilot's improper use of the carburetor heat. A factor to the accident was carburetor icing conditions.Feb 10, 1994 · N5639P · Substantial damageNTSB MIA94FA070Accident · 1 fatalField investigationFinal reportCessna 152 · Brooksville, FLThe pilot-in-command's failure to maintain a visual lookout and altitude while maneuvering after becoming lost/disoriented, resulting in an in-flight collision with trees and terrain. Contributing to the accident was the pilot's physical impairment due to…Feb 10, 1994 · N6613L · DestroyedNTSB LAX94LA120Accident · No injuriesLimited investigationFinal reportCessna A185F · Valley Springs, CAthe pilot's failure to ensure that the landing gear was in the correct configuration for a water landing.Feb 10, 1994 · N4833C · Substantial damageNTSB LAX94LA119Accident · No injuriesLimited investigationFinal reportCessna T188C · Winton, CAa partial loss of engine power in the takeoff initial climb due to fuel system contamination, and the pilot's inadequate preflight inspection of the aircraft.Feb 10, 1994 · N2086J · DestroyedNTSB LAX94LA118Accident · No injuriesLimited investigationFinal reportGansheimer Evans VP2 · Tucson, AZthe pilot's failure to attain and maintain sufficient flying speed during the first flight test of his experimental homebuilt. A factor in the accident was the pilot's selection of a propeller inadequate for the airframe and engine combination.Feb 10, 1994 · N187ES · Substantial damageNTSB FTW94FA082Accident · 2 fatalField investigationFinal reportCessna 421C · San Antonio, TXImproper servicing of the airplane with jet fuel, which resulted in preignition and/or detonation and subsequent failure of pistons in both engines. A factor related to the accident was: the lack of a restrictive mating nozzle on the refueling truck.Feb 10, 1994 · N741CA · DestroyedNTSB CHI94IA081Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Chicago, ILAn inadequate procedure for handling of wheel chocks by company maintenance and operations personnel. Factors associated with this accident were an inadequate inspection of the airplane by company maintenance personnel, and an inadequate pre-flight inspection…Feb 10, 1994 · N408PE · Minor damageNTSB ANC94LA033Accident · No injuriesLimited investigationFinal reportCessna 180A · Anchorage, AKThe failure of the pilot-in-command to maintain directional control of the airplane during the landing rollout. Contributing to the accident was the pilot's lack of recent experience in the airplane.Feb 10, 1994 · N288LS · Substantial damageNTSB ANC94FA032Accident · 1 fatalField investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's failure to maintain airspeed while maneuvering at low altitude. A factor in the accident was the student pilot's inadequate training.Feb 10, 1994 · N7523H · DestroyedNTSB MIA94FA069Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Vicksburg, MSFailure of the pilot-in-command to maintain the proper glidepath while on a straight in approach resulting in the inflight collision with trees short of the runway. Contributing to the accident was the dark night condition.Feb 9, 1994 · N1645H · Substantial damageNTSB LAX94LA117Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Corona, CAa loss of engine power due to water contamination in the fuel, and the instructor's failure to perform an adequate preflight inspection.Feb 9, 1994 · N49157 · Substantial damageNTSB CHI94FA080Accident · 1 fatalField investigationFinal reportCessna 320F · Goshen, INthe pilot-in-command's continued operation with known deficiencies in equipment. Factors were ice on the windshield and the pilot-in-commands visual outlook not possible.Feb 9, 1994 · N618X · Substantial damageNTSB SEA94LA059Accident · No injuriesLimited investigationFinal reportCessna T210N · Havre, MTAn undetermined loss of engine power.Feb 8, 1994 · N5520A · Substantial damageNTSB LAX94FA116Accident · 1 fatalField investigationFinal reportCessna 310R · La Jolla, CAthe pilot's failure to maintain control of the airplane. Factors in the accident were the dark night lighting conditions, moderate to severe turbulence, and heavy rain.Feb 8, 1994 · N1976Y · DestroyedNTSB ATL94FA047Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Murphy, NCThe failure of the pilot to maintain clearance from the terrain. Factors in the accident were the dark night, and the mountainous terrain.Feb 8, 1994 · N9637J · Substantial damageNTSB ANC94LA031Accident · No injuriesLimited investigationFinal reportCessna 207 · Kwigillingok, AKThe pilot-in-command's failure to maintain the proper airspeed which resulted in an inadvertent stall and his failure to initiate a go-around when the runway environment was not clearly defined. A factor in the accident was the fog.Feb 8, 1994 · N6470H · Substantial damageNTSB SEA94LA058Accident · No injuriesLimited investigationFinal reportCessna 402C · Billings, MTThe nose gear actuator froze. A factor to the accident was temperature extremes.Feb 7, 1994 · N2718Y · Substantial damageNTSB LAX94LA135Accident · No injuriesLimited investigationFinal reportCessna 340A · Dunsmuir, CAThe mechanics improper maintenance of the airplane's left brake system by failing to service its hydraulic reservoir. The lack of hydraulic fluid in the left brake reservoir which precipitated the left brake failure is a factor in this accident.Feb 7, 1994 · N1362C · Substantial damageNTSB CHI94LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Sebewaing, MIwas the pilot-in-command's failure to maintain directional control. Factors were the icy runway and a snowbank.Feb 7, 1994 · N94269 · Substantial damageNTSB BFO94LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Norfolk, VAFatigue failure of the engine mounting bolt which resulted in loss of engine power and subsequent on ground collision with the terrain.Feb 7, 1994 · N38780 · Substantial damageNTSB MIA94LA068Accident · No injuriesLimited investigationFinal reportCessna 172RG · Orlando, FLThe failure of the student pilot to follow instuctions given by ground control and the failure of both pilots to maintain proper obstruction clearance between aircraft.Feb 6, 1994 · N9346D · 2 aircraft · Substantial damageNTSB MIA94FA067Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Sugarloaf Key, FLWas the failure of the pilot-in-command to perform a visual lookout and maintain his altitude. Contributing to the accident was the dark night, over water, visual descent.Feb 6, 1994 · N626CN · DestroyedNTSB LAX94LA115Accident · 2 fatalLimited investigationFinal reportLampman Kitfox IV · Banning, CA1) The pilot's decision to fly in mountainous terrain at a low level, and 2) his failure to maintain adequate airspeed while maneuvering to reverse direction in a box canyon, which resulted in an inadvertent stall spin.Feb 6, 1994 · N92NL · DestroyedNTSB LAX94LA114Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Borrego Springs, CA1) the pilot's decision to takeoff in an aircraft with a known, yet unresolved, engine performance deficiency, and 2) the pilot's failure to maintain an adequate airspeed while maneuvering back to the runway. A factor in the accident was the weld repair of…Feb 6, 1994 · N8855S · Substantial damageNTSB CHI94LA079Accident · Serious injuriesLimited investigationFinal reportRoberts RV-6A · Richland, MOLoss of engine power (during flight) for an undetermined reason, after the pilot experienced loss of engine power before takeoff for an unknown reason.Feb 6, 1994 · N63JR · Substantial damageNTSB CHI94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Wichita, KSThe pilot's failure to attain the proper touchdown point and delay in aborting the landing. The pilot's inadequate training was a factor.Feb 6, 1994 · N8119W · Substantial damageNTSB CHI94FA076Accident · 2 fatalField investigationFinal reportBeech 95 · Chesterfield, MOincorrect installation of the fuel selector valves during mandatory service bulletin modification which resulted in fuel starvation to both engines and failure of the pilot-in-command to maintain aircraft control during emergency descent. A factor was…Feb 6, 1994 · N9903R · DestroyedNTSB LAX94LA113Accident · No injuriesLimited investigationFinal reportCessna 175 · Oakdale, CAthe pilot's failure to maintain an adequate visual lookout, and his failure to adequately communicate his postion and intentions on the Common Traffic Advisory Frequency. A factor in the accident was the pilot's misidentification of the Cessna aircraft he was…Feb 5, 1994 · N7597M · 2 aircraft · Substantial damageNTSB CHI94LA078Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Delavan, WIthe pilot-in-command's not maintaining directional control and his inadequate compensation for wind conditions. Factors were icy runway and crosswind.Feb 5, 1994 · N38203 · Substantial damageNTSB MIA94GA099Incident · No injuriesFinal reportCessna 172N · Opa-Locka, FLInadequate maintenance inspection and lubrication of the flap rollers which resulted in the left flap inboard roller becoming jammed in the track during flap retraction.Feb 4, 1994 · N9003E · Minor damageNTSB LAX94LA112Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Arcata, CAfuel starvation resulting from the pilot's improper in-flight planning and his failure to correctly monitor the aircraft's fuel system and to position the selector valve on a tank containing fuel.Feb 4, 1994 · N93159 · Substantial damageNTSB BFO94LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Taunton, MAA total loss of engine power for undetermined reasons. A factor in this accident was the lack of suitable terrain to enable the successful completion of the forced landing.Feb 4, 1994 · N1877Q · Substantial damageNTSB SEA94LA057Accident · Minor injuriesLimited investigationFinal reportBell 206B · Cathlamet, WALoad jettison was not performed.Feb 3, 1994 · N43823 · Substantial damageNTSB SEA94FA055Accident · 2 fatalField investigationFinal reportBeech S35 · Ashland, ORPoor in-flight planning/decision. Factors to the accident were: clearance was not maintained and poor supervision.Feb 3, 1994 · N50VT · DestroyedNTSB MIA94LA066Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tamarac, FLThe loss of engine power for undetermined causes.Feb 3, 1994 · N15635 · Substantial damageNTSB MIA94LA065Accident · No injuriesLimited investigationFinal reportOconnell LAZER-200 · St. Petersburg, FLThe failure of the pilot of the conventional gear airplane to maintain a visual lookout for other aircraft.Feb 3, 1994 · N199J · 2 aircraft · Substantial damageNTSB MIA94FA064Accident · 2 fatalField investigationFinal reportCessna T210M · Prentiss, MSA total loss of engine power due to the number five piston crown structure sustaining detonation/pre-ignition damage for undetermined reasons. The number two connecting rod and rod bolts failed due to an oil distress event. This resulted in a subsequent…Feb 3, 1994 · N6572M · DestroyedNTSB FTW94LA081Accident · No injuriesLimited investigationFinal reportCannon Starduster II · Brazoria, TXThe pilot's improper flare technique during the forced landing. A factor was the fuel contamination induced partial power loss.Feb 3, 1994 · N21RC · Substantial damageNTSB FTW94LA080Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Paris, ARFailure by the pilot in command to have annual maintenance inspections performed on the aircraft.Feb 3, 1994 · N7141M · Substantial damage