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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA03LA023Accident · No injuriesLimited investigationFinal reportBell 47G · Idaho Falls, IDIn-flight loss of engine power for undetermined reasons.NTSB FTW03FA071Accident · 2 fatalField investigationFinal reportGrumman American AA-1A · Shreveport, LAThe pilot's failure to maintain adequate airspeed resulting in a stall.NTSB DEN03LA027Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Dev. CH2000 · Milford, UTthe inadequate altitude chosen by the flight instructor, resulting in inadequate clearance and subsequent collision with mountainous terrain. Contributing factors were the instructor's failure to consult pertinent VFR sectional charts for the area, and the…NTSB MIA03LA035Accident · Minor injuriesLimited investigationFinal reportLonnie Johnson RV6A · Peachtree City, GAThe failure of the pilot to activate carburetor heat control during cruise flight after experiencing a loss of engine rpm, inadequate carburetor heat system by the builder, and the unsuitable terrain encountered by the pilot-in-command during the forced…NTSB LAX03FA057Accident · 1 fatalField investigationFinal reportBeech 95 · Tucson, AZa loss power in the right engine due to an excessively rich mixture that was the result of the pilot's failure to secure the priming control prior to takeoff. Also causal was the pilot's failure to follow the single engine procedures specified in the…NTSB FTW03LA069Accident · Serious injuriesLimited investigationFinal reportWood Thorp T-18 · Stephenville, TXThe pilot's loss of directional control as result of his failure to compensate for the prevailing wind conditions. A contributing factor was the gusty crosswinds.NTSB CHI03LA048Accident · 1 fatalLimited investigationFinal reportAir Command Commander Elite · Lansing, ILThe inadvertent pilot induced oscillation. Factor to the accident was the wind gusts.NTSB NYC03LA034Accident · No injuriesLimited investigationFinal reportSocata TB 9 · Mount Union, PAThe pilot's delay in aborting the takeoff. A factor was the soft runway.NTSB FTW03LA072Accident · No injuriesLimited investigationFinal reportBell 206-L4 · High Island 471The pilot's attempt to takeoff during known adverse weather conditions and failure to maintain control of the helicopter while maneuvering. Contributing factors were the gusty and high wind conditions.NTSB ATL03LA028Accident · No injuriesLimited investigationFinal reportCessna 172F · Stuart, FLThe pilot's inflight encounter with wind shear on final approach, which resulted in an inflight loss of control and subequent uncontrolled descent into trees.NTSB ATL03FA030Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Austell, GAThe pilot's inadequate preflight and in-flight planning/decision that resulted in fuel exhaustion, and subsequent loss of engine power.NTSB NYC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-18A 150 · Blairstown, NJThe pilot's failure to maintain directional control during the landing roll.NTSB LAX03LA056Accident · No injuriesLimited investigationFinal reportNicholson Lancair 320 · Corona, CAThe pilot/builder's improper maintenance procedure for reattaching a high-pressure oil line, which resulted in the oil line disconnecting during flight, followed by a loss of oil and engine seizure.NTSB FTW03LA070Accident · No injuriesLimited investigationFinal reportCessna T207 · Brownsville, TXThe loss of engine power due to the separation of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB DEN03FA028Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Steamboat Spgs, COthe pilot's inadequate in-flight planning/decision making resulting in insufficient altitude to fly over the mountain, and the subsequent inadvertent stall/mush into tree covered mountainous terrain. Contributing factors were the tail wind and high density…NTSB LAX03LA055Accident · 1 fatalLimited investigationFinal reportLipscomb Lancair 235 · Payson, AZthe pilot's failure to maintain an adequate airspeed during an aborted landing that resulted in an inadvertent stall/spin. A contributing factor in the accident was the pilot's lack of familiarity with the airplane.NTSB FTW03LA068Accident · 2 fatalLimited investigationFinal reportBarber Glasair · Conroe, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall and a subsequent loss of control.NTSB FTW03FA067Accident · 1 fatalField investigationFinal reportBeech F-35 · Addison, TXThe pilot's mismanagement of the fuel supply by his failure to switch fuel tank positions which resulted in fuel starvation and the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN03LA029Accident · No injuriesLimited investigationFinal reportBeech F33A · Durango, COthe pilot's failure to extend the landing gear. A contributing factor is the pilot's failure to follow the checklist.NTSB ANC03LA021Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Nikolai, AKAn improper and undocumented major repair of the elevator torque tube support assembly by an unknown person, which resulted in an in-flight disconnection of the airplane's right elevator, and a jammed rudder. A factor associated with the accident is the…NTSB MIA03WA052Accident · No injuriesForeign investigationCessna 208B · San Pedro, BelizeNTSB ATL03LA027Accident · Minor injuriesLimited investigationFinal reportCessna 182S · Nashville, TNThe pilot's failure to maintain visual lookout and his inattentiveness during taxi that resulted in an on ground collision with an embankment. A factor was the fog.NTSB WAS03WA005Accident · No injuriesForeign investigationCessna 404 · Windhoek, NamibiaNTSB NYC03LA033Accident · No injuriesLimited investigationFinal reportMBB BK 117 A-4 · Albany, NYThe inadvertent encounter with a downdraft during engine start, which flexed the main rotor blades and subsequently damaged the tail boom assembly. A factor related to the accident was the failure of the operator to comply with a service bulletin.NTSB NYC03LA032Accident · No injuriesLimited investigationFinal reportCessna 172S · Akron, OHThe pilot's improper flare which resulted in a hard landing.NTSB MIA03CA037Accident · No injuriesData collectionFinal reportPiper PA-30 · Tallahassee, FLthe pilot's improper start procedure which resulted in an unintentional engine start, and unoccupied aircraft collision with hangar structure.NTSB DEN03LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Spanish Fork, UTthe pilot's inadequate preflight planning and preparation and his in-flight decision/planning resulting in fuel exhaustion. A contributing factor was the rough, frozen terrain at the landing site.NTSB MIA03FA034Accident · 1 fatalField investigationFinal reportCessna 208B · Manteo, NCThe pilot's continued descent below the minimum descent altitude, for undetermined reasons, while performing a NDB approach, resulting in the airplane crashing into water 1.5 miles from the airport. A factor in the accident was a cloud ceiling below the…NTSB DEN03FA025Accident · 2 fatalField investigationFinal reportCessna 421 · Akron, COThe fractured connecting rods and the pilot not maintaining aircraft control following the engine failure. Factors contributing to the accident were the low altitude, the pilot not maintaining minimum controllable airspeed following the engine failure, the…NTSB ATL03LA031Accident · No injuriesLimited investigationFinal reportBeech F-35 · Hollywood, FLThe pilot exceeded the design limits of the airplane which resulted in an in flight structural failure.NTSB SEA03LA021Accident · No injuriesLimited investigationFinal reportHughes 369D · Boise, IDThe failure of the operator's maintenance personnel to properly rig the left/right seat twistgrip throttles to the engine fuel control, the pilot in command's failure to adhere to the rotorcraft flight manual, and the check pilot's premature flare during the…NTSB FTW03FA064Accident · 1 fatalField investigationFinal reportBeech BE-58 · Egypt, ARThe pilot's inadvertent flight into severe icing conditions. A contributing factor was the pilot's inadequate preflight planning.NTSB CHI03LA075Accident · No injuriesLimited investigationFinal reportCessna 172S · Tea, SDThe student pilot's improper flare. The pilot's lack of experience and diverted attention were factors.NTSB SEA03LA020Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1 · Chehalis, WAThe total loss of engine power, for undetermined reasons, while the aircraft was on a VFR final approach. No suitable terrain for landing and water were factors.NTSB LAX03FA054Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Dolan Springs, AZthe pilot's inadequate visual lookout and failure to maintain clearance from power lines. A factor was the pilot's decision to conduct cruise flight at a low altitude.NTSB FTW03LA074Accident · No injuriesLimited investigationFinal reportCessna 170A · West Helena, ARThe pilot's failure to maintain directional control during landing. A contributing factor was the deflated tire.NTSB FTW03LA066Accident · No injuriesLimited investigationFinal reportHughes 369E · Fritch, TXThe loss of engine power due to the failure of the generator input drive-end bearing, which resulted in excessive vibrations that induced a fatigue fracture of the Pc line leading to the engine fuel control unit. A contributing factor was the lack of suitable…NTSB CHI03LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Carleton, MIThe #2 cylinder exhaust valve failed due to undetermined reasons. A factor associated with the accident was the soft terrain encountered during the forced landing.NTSB ATL03LA026Accident · No injuriesLimited investigationFinal reportPreceptor Ultra pup · Smithville, TNThe pilot's inadequate preflight fuel planning of fuel resulted in fuel starvation, the total loss of engine power and the subsequent forced landing.NTSB LAX03LA053Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAthe student pilot's excessive use of the elevator control that resulted in an inadvertent lift-off and his failure to maintain/attain adequate airspeed, which resulted in a stall and hard landing.NTSB IAD03FA024Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Woodbury, CTAn engine fire for undetermined reasons, which resulted in the pilot's loss of control, and the airplane's subsequent impact with terrain.NTSB FTW03LA065Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Denver City, TXThe pilot's inadequate compensation for the prevailing wind conditions. A contributing factor was the crosswind.NTSB ATL03FA025Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Macon, GAThe loss of engine power due to oil starvation.NTSB SEA03WA030Accident · 2 fatalForeign investigationLancair IV · Geelong, AustraliaNTSB FTW03LA062Accident · No injuriesLimited investigationFinal reportCessna 195 · Wink, TXThe separation of the main landing gear axle bolt from the landing gear assembly.NTSB FTW03LA061Accident · 1 fatalLimited investigationFinal reportCreekmore Team Rocket F-1 · Rosenberg, TXThe in-flight separation of the vertical stabilizer as a result of the builder's failure to install the upper attachment fitting for the vertical fin aft spar.NTSB CHI03LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Osage Beach, MOFuel Starvation due to the failure of the mechanical fuel pump and the inoperable electric fuel pump caused by the electrical system failure. Factors were the unsuitable terrain and the trees.NTSB MIA03WA032Accident · 3 fatalForeign investigationPiper PA-46-500TP · Badearic Island, SpainNTSB ANC03LA019Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Soldotna, AKThe flightcrew's selection of an unsuitable landing area, which resulted in a loss of directional control and an on ground encounter with terrain. A factor associated with the accident was a snow-covered, unplowed runway.NTSB ANC03GA020Accident · 1 fatalFinal reportAviat A-1B · King Salmon, AKThe pilot's failure to maintain adequate airspeed which resulted in an in-flight collision with terrain.