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 DEN01FA151Accident · 2 fatalField investigationFinal reportAviat A-1 · Montrose, COthe pilot's intentional abrupt maneuver immediately after takeoff and the subsequent loss of aircraft control. Contributing factors were high density altitude weather conditions, and the airplane improper weight and balance.NTSB CHI01FA290Accident · 1 fatalField investigationFinal reportNavion L-17B · Newaygo, MIThe pilot inadvertently positioning the fuel selector in an intermediate position, resulting in a loss of engine power. An additional cause was the pilot's failure to verify the fuel selector position during the engine restart attempt. Factors to the accident…NTSB ANC01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nenana, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was trees.NTSB SEA01LA156Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Twin Falls, IDNose over during the landing roll for undetermined reasons.NTSB LAX01LA287Accident · No injuriesLimited investigationFinal reportCessna 150M · Murrietta, CAThe failure of the muffler assembly causing a fuel line to overheat, resulting in vapor lock, and a subsequent engine failure followed by an emergency landing in rough terrain.NTSB FTW01FA188Accident · 1 fatalField investigationFinal reportCessna 152 · Weatherford, TXThe student pilot's improper decision making in that he landed with a tailwind and failed to execute a go-around, which resulted in a runway overrun. Contributing factors were the inaccurate reading of the left fuel gage as a result of improper maintenance by…NTSB CHI01LA294Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Alice, NDThe pilot's unsuccessful recovery from an intentional aerobatic stall/spin maneuver. Contributing to the accident were the pilot's impairment (alcohol), and his psychological condition.NTSB CHI01LA288Accident · No injuriesLimited investigationFinal reportCessna 188 · Almond, WIthe pilot failed to maintain clearance from the corn crop. Additional factors were the inoperative spray pump, the corn crop, and the pilot's diverted attention.NTSB CHI01LA282Accident · No injuriesLimited investigationFinal reportHoskins Quickie Q2 · Carbondale, ILThe failure of the tailwheel spring. A factor was the directional control not possible by the pilot.NTSB ANC01LA125Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Sparrevohn, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were rough/uneven terrain, and an overload failure of the main landing gear landing strut.NTSB ANC01LA122Accident · No injuriesLimited investigationFinal reportCessna 185F · Cordova, AKThe pilot's inadequate compensation for wind conditions during takeoff. Factors associated with the accident were trees and a variable wind.NTSB ANC01LA118Accident · No injuriesLimited investigationFinal reportThomson Avid Flyer · Chugiak, AKThe loss of engine power during initial climb due to a broken spark plug.NTSB NYC01LA213Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Davidsville, PAThe pilot's failure to abort the takeoff attempt. Factors included the pilot's failure to use both magnetos, and his failure to utilize soft field takeoff procedures.NTSB NYC01FA212Accident · 1 fatalField investigationFinal reportPitts S-2B · Shirley, NYThe pilot under instruction's failure to maintain adequate airspeed, and the flight instructor's inadequate remedial action during a simulated engine-out approach, which resulted in an inadvertent stall, and subsequent ground impact.NTSB MIA01LA227Accident · No injuriesLimited investigationFinal reportCessna 172S · Gadsden, ALthe pilot misjudged the flare, resulting in a hard landing, and impact with the runway.NTSB LAX01TA284Accident · No injuriesFinal reportAero Commander 500S · Elko, NVThe main landing gear collapsed for undetemined reasons.NTSB FTW01LA187Accident · Serious injuriesLimited investigationFinal reportBeech F33C · Sugarland, TXthe pilot's inadvertent stall of the airplane during the base/final approach for landing which resulted in a collision with terrain. A contributing factor was the pilot's diverted attention to an open cockpit door.NTSB DEN01LA150Accident · No injuriesLimited investigationFinal reportHughes 269C · Tucumcari, NMfailure of the pilot-in-command to maintain adequate terrain clearance. Contributing factors were the unsuccessful low altitude flight maneuver, and the high density altitude weather conditions.NTSB ANC01LA121Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe pilot's inadequate compensation for gusty wind conditions. Factors associated with the accident were the pilot's inadequate weather evaluation, and wind gusts.NTSB ANC01LA120Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Kenai, AKThe total loss of engine power during takeoff for an undetermined reason.NTSB ANC01LA119Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Glennallen, AKThe pilot's inadequate compensation for wind conditions during takeoff. A factor associated with the accident was a variable wind.NTSB MIA01LA224Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A320-232 · Needles, CAan inadvertent in-flight encounter with turbulence.NTSB CHI01LA287Accident · No injuriesLimited investigationFinal reportCessna 305 · Vichy, MOThe pilot failed to maintain directional control of the airplane during landing. The crosswind was a factor.NTSB ANC01LA115Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Palmer, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was rough/uneven terrain.NTSB SEA01LA153Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Enumclaw, WAThe premature release of the towline and the pilot's improper selection of a landing area following the release. Factors include improper preflight planning.NTSB MIA01LA222Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Mitchell, GAThe poor in-flight planning by the pilot-in-command resulting in the total loss of engine power due to fuel starvation.NTSB MIA01LA220Accident · 1 fatalLimited investigationFinal reportPiper J-4A · Mosheim, TNThe failure of the student pilot to maintain altitude clearance during a balked landing go-around resulting in the collision with a utility pole, transmission wires, and a ground borne vehicle.NTSB MIA01FA223Accident · 3 fatalField investigationFinal reportBeech A23 · Blairsville, GAThe failure of the pilot to maintain airspeed resulting in an inadvertent stall an subsequent in-flight collision with trees then the ground during the uncontrolled descent.NTSB FTW01LA185Accident · Minor injuriesLimited investigationFinal reportBeech A-36TC · Fort Worth, TXthe partial loss of engine power for an undetermined reason and the pilot's decision to initiate the takeoff downwind.NTSB ATL01FA094Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Rienzi, MSThe pilot experienced spatial disorientation, which resulted in an in-flight loss of control and subsequent collision with trees and terrain. A factor was the dark night condition.NTSB ANC01LA126Accident · No injuriesLimited investigationFinal reportFreeman Glastar · Glennallen, AKThe pilot's failure to abort the landing. Factors associated with the accident were the pilot's selection of an unsuitable landing area, and his failure to attain a proper touchdown point. An additional factor was a tailwind.NTSB ANC01LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Palmer, AKThe pilot's excessive use of brakes during the landing roll.NTSB LAX01LA283Accident · No injuriesLimited investigationFinal reportAerospatiale AS 355F1 · Vinton, CAThe pilot's selection of an unsuitable landing site, which caused "brown-out" conditions during departure liftoff and resulted in loss of control of the helicopter.NTSB LAX01LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172-A · Groveland, CAa loss of engine power due to water contamination forced the pilot to land in an unsuitable area resulting in collision with a tree.NTSB FTW01LA200Accident · No injuriesLimited investigationFinal reportCessna 182A · Salado, TXA loss of engine power for undetermined reasons. A factor was the pilot's failure to maintain airspeed during the forced landing resulting in a stall. This report was modified on December 2, 2005.NTSB FTW01LA192Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Dover, ARthe pilot's delay in aborting the landing.NTSB DEN01LA149Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Rock Springs, WYthe mechanic's failure to perform an airworthiness directive, which resulted in the loss of engine oil through a partially failed oil filter converter plate gasket, and subsequent failure of a connecting rod during cruise flight. A contributing factor was the…NTSB CHI01LA285Accident · Serious injuriesLimited investigationFinal reportWaters Avid Bandit · Northville, MIfuel starvation due to the pilot's improper fuel calculations. A factor was the concrete building.NTSB CHI01LA284Accident · Minor injuriesLimited investigationFinal reportCameron Balloons Shuttle 90 · Centralia, ILThe balloon envelope fire. A contributing factor was the flammability of the envelope.NTSB NYC01LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Newark, OHThe student pilot's failure to maintain aircraft control during an aborted landing. A factor in this accident was the crosswind conditions.NTSB MIA01LA219Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Wilgrove, NCThe failure of maintenance personal to properly reconnect the throttle-cable-to carburetor attachment, resulting in a throttle cable disconnection while in the landing pattern, and collision with trees. A factor in the accident was the failure of the pilot to…NTSB MIA01LA218Accident · Serious injuriesLimited investigationFinal reportCessna 182R · Winder, GAA total loss of engine power due to fatigue failure of the number two piston immediately after takeoff, resulting in collision with trees and the terrain during an emergency descent.NTSB LAX01LA281Accident · 2 fatalLimited investigationFinal reportJohnson Lancair 360 · Placerville, CAIn-flight loss of control for undetermined reasons.NTSB FTW01LA186Accident · No injuriesLimited investigationFinal reportCessna 421B · New Braunfels, TXthe pilot's inadequate flare of the airplane resulting in a hard landing. A contributing factor was the crosswind.NTSB FTW01LA184Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Fabens, TXthe pilot's inadequate preflight resulting in loss of engine power due to fuel exhaustion. A contributing factor was the power line.NTSB SEA01TA152Accident · Minor injuriesFinal reportWSK PZL Mielec M-18 Dromader · Ukiah, ORAn inadequate recovery from a bounced landing and directional control was not maintained during landing. A high flare and a fence were factors.NTSB MIA01LA217Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerfield, FLThe poor in-flight planning decision by the student pilot for his failure to turn around to avoid low ceilings resulting in a precautionary landing in a field. A contributing factor in the accident was the pilot's lack of total experience. A finding in the…NTSB LAX01LA280Accident · Serious injuriesLimited investigationFinal reportHumphreys Stitts SA6B · Elko, NVThe failure of the pilot-in-command to reverse course in a timely manner after flying into a box canyon. Factors in the accident were the pilot's lack of familiarity with the aircraft and the local terrain.NTSB FTW01IA183Incident · No injuriesIncident investigationFinal reportBoeing 737-347 · DFW Airport, TXThe local controller clearing the taxiing aircraft to cross the runway in front of the aircraft on takeoff roll. Contributing factors were the local controller's failure to follow FAA procedures and directives to visually scan the runway prior to issuing the…NTSB CHI01LA309Accident · No injuriesLimited investigationFinal reportCessna T210N · Fargo, NDthe emegency procedure not followed by the pilot.