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 CHI89FA196Accident · 3 fatalField investigationFinal reportBeech A36TC · Greencastle, INFailure of the pilot to maintain proper altitude during a visual approach at dusk. Factors related to the accident were: light conditions at dusk, the pilot's visual perception, and the trees.NTSB CHI89DEM10Accident · 1 fatalFinal reportFletcher SONERAI-2L · Interlochen, MILoose cylinder due to improper maintenance by the pilot/owner, which resulted in overheating and failure of the aluminum cylinder head. The presence of trees was considered to be a factor.NTSB ANC89LA178Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Shotgun Hills, AKThe pilot's failure to adequately evaluate the existing weather conditions and to maintain control of the aircraft. Contributing to the accident was the pilot's overconfidence in both personal ability and the ability of the aircraft along with the downdraft…NTSB ANC89LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKImproper planning/decision by the pilot. Factors related to the accident were: the pilot's overconfidence in himself and the aircraft, and the strong/gusty wind conditions.NTSB SEA89FA183Accident · 3 fatalField investigationFinal reportCessna 182F · Diamond Lake, ORImproper inflight planning and decision by the pilot in command who continued VFR flight into IMC conditions while attempting to fly through a mountain pass. Contributing factors were the low ceiling and rain weather conditions and the mountainous, hilly…NTSB SEA89FA180Accident · 2 fatalField investigationFinal reportCessna 177RG · Nyssa, ORFailure of the pilot to attain sufficient altitude before flying over mountainous/hilly terrain. Factors related to the accident were: dark night, rising/mountainous terrain, and probable impairment from a prescription drug.NTSB LAX89LA333Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Palo Alto, CAA loss of engine power due to fuel starvation. The fuel starvation was the result of vane particles from the deteriorated electric fuel pump restricting the upstream flow of fuel.NTSB ATL89LA221Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Hatteras, NCLoss of engine power for an unknown reason.NTSB ATL89DKG06Accident · 2 fatalFinal reportBell UH-1B · Plains, GAImproper modification of the helicopter by the company/operator, and failure of the spray boom, which resulted in mast bumping, and subsequent failure of the main rotor assembly.NTSB ANC89LA176Accident · No injuriesLimited investigationFinal reportCessna 185 · Trading Bay, AKPilot in commands failure to perform an adequate visual approach resulting in collision with a tree.NTSB NYC89LA217Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1C · Philadelphia, PAFuel starvation, due to the pilot's failure to assure the fuel selector was positioned to a tank with adequate fuel for landing, and his failure to follow the proper emergency procedure after the tank emptied.NTSB NYC89DFA02Accident · 1 fatalFinal reportNiedzielski COOT-A · Marcy, NYFuel system contamination and the pilot's failure to maintain adequate airspeed, which resulted in a stall/spin.NTSB MKC89LA200Accident · No injuriesLimited investigationFinal reportHughes 269C · Bloomington, MNFailure of the engine crankshaft. The light conditions at dawn and the vehicles were considered to be contributing factors.NTSB MIA89LA258Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Kissimmee, FLInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: false fuel gage indications and trees in the emergency landing area.NTSB MIA89LA257Accident · No injuriesLimited investigationFinal reportCessna 150L · Rockledge, FLFailure of the student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. The gusty crosswind and proximity of the parked aircraft were related factors.NTSB LAX89LA330Accident · No injuriesLimited investigationFinal reportCessna 180 · Flagstaff, AZFailure of the left brake. The pilot's failure to maintain directional control with rudder and tailwheel steering was considered to be a related factor.NTSB LAX89DVA11Accident · 1 fatalFinal reportSkilling VARI-EZE · Oakdale, CAThe pilot's failure to maintain directional control and the delayed initiation of the aborted landing. A factor was lack of aircraft familiarity.NTSB CHI89LA197Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lebanon, ILFailure of the pilot to use all available runway and his misjudgement of the available distance (runway length) for landing. Contributing factors were: inadequate preflight planning/preparation, and the runway and terrain conditions.NTSB CHI89LA195Accident · No injuriesLimited investigationFinal reportBeech 36 · Princeton, ILThe pilot had excessive airspeed, misjudged the landing distance, and did not go around. The high obstructions (trees),wet runway, ditch, and uneven terrain (roadway) were contributing factors.NTSB CHI89LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mt. Horeb, WIThe pilot's failure to follow proper procedures for breaking-in new brakes and the excessive touchdown speed. Contributing factors were the worn brakes.NTSB CHI89DEM09Accident · Minor injuriesFinal reportHiller UH-12E · Hudsonville, MIThe fatigue failure of one of the tension-torsion pins.NTSB CHI89DEE06Accident · Minor injuriesFinal reportHowe Quickie Q2 · Lakeinthehills, ILThe pilot failed to maintain directional control of the airplane during a bounced landing. A factor related to the accident was the pilot's evasive maneuver to avoid rolling into a stone quarry.NTSB ATL89FA220Accident · 1 fatalField investigationFinal reportAerospatiale AS 350D · Chamblee, GAFailure of the main rotor swashplate bearing due to lack of lubricant.NTSB ANC89DAG02Accident · 1 fatalFinal reportEvanson Long EZ/52 · Palmer, AKPilot-in-command's failure to maintain the proper altitude.NTSB LAX89LA331Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scottsdale, AZImproper in-flight planning/decision by the instructor pilot (CFI). Factors related to the accident were: the cfi's lack of familiarity with the geographic area, and the fence.NTSB LAX89LA327Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Newport Beach, CAThe fatigue failure of the engine's crankshaft, resulting in a total loss of power over unsuitable terrain. The pilot ditched the airplane because he was unable to glide to shore.NTSB FTW89LA174Accident · No injuriesLimited investigationFinal reportBell 206BII · Grand Prairie, TXThe pilot's decision to execute an abrupt maneuver while hovering downwind, which led to a reduction in rotor RPM and subsequent hard landing.NTSB FTW89DQG07Accident · No injuriesFinal reportCessna T188C · Spur, TXPartial power loss for undetermined reasons. Contributing to the accident was the farm equipment parked near the end of the runway.NTSB DCA89MA076Accident · 10 fatalClass 1 · MajorFinal reportde Havilland DHC-6-300 · Grand Canyon, AZImproper pilot techniques and crew coordination during the landing attempt, bounce, and attempted go-around.NTSB SEA89LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · East Sound, WAThe student pilot's failure to maintain directional control.NTSB SEA89LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Portland, ORThe pilot's poor inflight planning. Contributing to the accident was the wake turbulence and remedial action not possible.NTSB MIA89TL#07Accident · No injuriesClass 3Final reportGrumman G-164B · Mims, FLNTSB LAX89LA329Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Warner Springs, CALoss of engine power for an unknown reason. The obstruction (tree) was a factor.NTSB LAX89LA323Accident · No injuriesLimited investigationFinal reportCessna 177RG · Tucson, AZA loss of engine power due to the pilot's improper use of the aircraft's powerplant controls. A contributing factor was the pilot's limited experience in a Cessna 177RG.NTSB FTW89FA172Accident · 1 fatalField investigationFinal reportCessna 210D · Covington, LAThe pilot in command's disregard of the weather information provided during two briefings and his decision to continue VFR flight into IMC condtions. Factors contributing to the accident were the pilot's lack of night and instrument experience.NTSB ATL89IA219Incident · No injuriesIncident investigationFinal reportCanadair CL-44 · Greensboro, NCThe first officer's failure to follow approved missed approach procedures, and his attempt to take the flight controls from the captain who was flying the airplane.NTSB ANC89LA175Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cottonwood Crk, AKImproper inflight planning/decision by the pilot and his failure to maintain adequate airspeed. Factors related to the accident were: the pilot's low pass over rising terrain and the aircraft's subsequent impact with alder bushes (high vegetation).NTSB SEA89LA177Accident · Minor injuriesLimited investigationFinal reportBell 47G · Corvallis, ORStudent pilot's improper use of the collective control while performing hovering autorotations, and the instructor's inadequate supervision of the student's actions, which resuled in hard landings. In addition, the engine mount was significantly weakened…NTSB LAX89LA322Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria · Auburn, CAThe pilot's inadvertent activation of nose down trim which resulted in a loss of control and collision with a tree. Contributing factor(s) was: the pilot's lack of experience in this type of airplane.NTSB FTW89LA173Accident · No injuriesLimited investigationFinal reportBeech B-19 · Mckinney, TXPilot's improper technique in recovery from a bounced landing. Factors contributing to the accident were the pilot's failure to maintain directional control during the go around.NTSB ANC89LA174Accident · No injuriesLimited investigationFinal reportCessna 180 · Redoubt Bay, AKImproper planning/decision by the pilot. Factors related to the accident were: the unfavorable runway and terrain conditions.NTSB SEA89LA179Accident · 2 fatalLimited investigationFinal reportLuscombe 8A · Mackay, IDThe pilot failed to maintain an adequate airspeed for flight. High density altitude was a factor.NTSB MKC89LA199Accident · No injuriesLimited investigationFinal reportCessna 150 · California, MOImproper use of the carburetor heat by the pilot resulting in the formation of carburetor ice and subsequent loss of power.NTSB MIA89LA256Accident · Serious injuriesLimited investigationFinal reportCooley LONG-EZ · Green Cove Spgs, FLImproper planning/decision by the pilot, which resulted in his failure (or inability) to align the acft with the runway during the landing. The low ceiling, tailwind, and ditch were related factors.NTSB MIA89FA253Accident · 2 fatalField investigationFinal reportCessna 172N · Ochopee, FLThe failure of the pilots of both airplanes to see and avoid each other while maneuvering.NTSB CHI89LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lebanon, OHThe pilot allowed his final approach airspeed to get too slow, he delayed in initiating remedial action, then attempted an aborted landing with inadequate airspeed, which resulted in an inadvertent stall. The pilot's lack total experience was considered a…NTSB ATL89LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · China Grove, NCPilot's loss of control during the final approach in that he failed to establish a proper glidepath. The airplane landed short of the runway. During the attempted go-around his improper use of rudder and aileron, following the application of full power,…NTSB ATL89LA217Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mt Pleasant, SCFailure of the pilot to slow the aircraft to the proper landing speed at the proper touchdown point or go around. The weather conditions, tailwind, lack of airport facilities (UNICOM not operating and windsock damaged), wet runway/hydroplaning conditions, and…NTSB LAX89LA325Accident · No injuriesLimited investigationFinal reportCessna 172 · Phoenix, AZThe pilot misjudged clearance between the wingtip and the blast deflector shield. The proximity of the shield was a related factor.NTSB LAX89LA321Accident · No injuriesLimited investigationFinal reportCessna 150 · Paradise, CAThe pilot's failure to adequately compensate for the existing wind conditions and to maintain adequate airspeed. Contributing to the accident were the adverse wind conditions.