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 ANC98LA073Accident · No injuriesLimited investigationFinal reportLake LA-4 · Saint Mary'S, AKThe pilot's diverted attention during takeoff, and his failure to maintain a proper climb rate. A factor associated with the accident was the presence of birds.NTSB SEA98LA096Accident · No injuriesLimited investigationFinal reportCessna 172R · Independence, ORA loss of power due to fatigue failure and cracking of an engine cylinder barrel.NTSB LAX98LA198Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Riverbank, CAThe pilot's inadequate visual lookout for on-coming ground traffic.NTSB LAX98LA197Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Shafter, CAThe aircraft's encounter with settling with power, which resulted from the pilot's decision to perform a steep downwind approach.NTSB LAX98LA196Accident · Minor injuriesLimited investigationFinal reportBeech 76 · San Martin, CAFailure of the instructor to adequately supervise the flight, which included ensuring that the student maintained the proper airspeed during the attempted go-around.NTSB LAX98LA195Accident · 1 fatalLimited investigationFinal reportBlackmore RV-4 · Sedona, AZThe pilot's attempt to perform aerobatics with insufficient terrain clearance altitude available to complete the maneuver. A factor was high density altitude.NTSB FTW98LA264Accident · Minor injuriesLimited investigationFinal reportLet Blanik L-13 · Hempstead, TXThe pilot's failure to maintain the proper rate of descent. Factor were the pilot's inadvertent lowering of the flaps instead of extending the spoilers, and his lack of experience in gliders.NTSB DCA98WA055Accident · Minor injuriesForeign investigationMcDonnell Douglas MD-11 · Manila, PhilippinesNTSB ANC98LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Nikiski, AKThe pilot's use of excessive brake application during landing roll.NTSB LAX98LA194Accident · No injuriesLimited investigationFinal reportScott Dragonfly · Mecca, CAThe pilot's inadequate preflight inspection and his failure to ensure sufficient fuel was in the airplane, which subsequently led to fuel exhaustion. A related factor was the soft terrain.NTSB FTW98LA268Accident · No injuriesLimited investigationFinal reportCessna 150L · Taft, TXThe pilot's failure to ensure that there was adequate fuel for the planned flight on board the airplane during the preflight inspection which resulted in a loss of engine power due to fuel exhaustion. A factor was the pilot's misjudgment of the glide distance…NTSB FTW98LA266Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Mcgehee, ARA loss of engine power for undetermined reasons.NTSB FTW98LA265Accident · Minor injuriesLimited investigationFinal reportPiper J3 · Midland, TXThe inadvertent ground loop during the landing roll. A factor was the sudden windshift.NTSB CHI98LA200Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Albion, MIthe pilot's improper preflight planning/preparation and his not refueling the airplane to avoid fuel exhaustion. Factors were the pilot's lack of certification, his not feathering the engine, and the trees.NTSB CHI98LA199Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Gregory, SDthe pilot's not maintaining control of the airplane during landing.NTSB ATL98LA083Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Destin, FLThe pilot's failure to maintain directional control and her failure to maintain adequate obstacle clearance during an attempted go-around. A factor was the pilot's inadequate compensation for the crosswind conditions.NTSB ATL98LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boynton Beach, FLThe pilot's inadequate preflight planning that resulted in a loss of engine power due to fuel exhaustion.NTSB ANC98LA075Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKThe total loss of engine power for undetermined reasons.NTSB SEA98LA095Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Starbuck, WAThe pilot-in-command's failure to maintain adequate visual lookout. A contributing factor was the unmarked transmission lines.NTSB FTW98LA267Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Edna, TXThe pilot's inadequate compensation for the existing wind conditions. Factors were the crosswind, the dust devils, and the confined landing area.NTSB ATL98LA087Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Pensacola, FLThe pilot's inadvertent activation of the parking brakes which resulted in the nose over during the landing roll.NTSB ATL98LA081Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Nicklesville, GAThe loss of engine power for undetermined reason. A factor was that weather conditions were favorable for the formation of carburetor ice.NTSB ANC98LA081Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Homer, AKThe loss of engine power due to fuel starvation, and an improper fuel selector valve. Factors in the accident were turbulent wind conditions, the improper replacement of the fuel selector valve by an airplane mechanic, and the failure of an FAA inspector to…NTSB ANC98LA071Accident · No injuriesLimited investigationFinal reportCessna 172 · Angoon, AKThe pilot's failure to maintain directional control during the aborted takeoff. A factor associated with the accident was rough and uneven terrain.NTSB SEA98LA094Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · North Plains, ORThe pilot's failure to maintain directional control and his failure to maintain clearance from a pole. Contributing factors were rain and an overcast which resulted in less than optimal conditions to detect the pole.NTSB FTW98LA262Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider LS-6A · Green River, UTThe pilot's failure to maintain airspeed. Factor's were the unforecasted weather (tail wind) and the inadvertent stall/spin.NTSB SEA98LA093Accident · 1 fatalLimited investigationFinal reportCessna 150 · Amboy, WAThe pilot's failure to maintain adequate altitude and/or clearance from terrain during a go-around attempt. Factors included a short landing area and trees in the landing area.NTSB NYC98LA126Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Taunton, MAa delayed decision by the pilot to abort the takeoff, which resulted in an overrun. A factor was false reading from the airspeed indicator.NTSB NYC98FA127Accident · 3 fatalField investigationFinal reportPiper 601P · Martinsburg, PAThe pilot's failure to maintain airspeed due to spatial disorientation, which resulted in an inadvertent stall and subsequent collision with terrain. A factor in the accident was the low ceiling.NTSB IAD98FA068Accident · 2 fatalField investigationFinal reportBeech F33A · Delaplane, VAThe pilot's inadequate in-flight decision which led to VFR flight into instrument meteorological conditions. Also causal was the pilot's failure to maintain adequate terrain clearance resulting in collision with mountainous terrain. Contributing factors were…NTSB FTW98LA261Accident · Minor injuriesLimited investigationFinal reportGisclair Murphy Renegade SP · Galliano, LAA loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB DCA98WA068Accident · No injuriesForeign investigationBell 205A1 · Paderborn, GermanyNTSB CHI98LA198Accident · Serious injuriesLimited investigationFinal reportBell 47G · Le Center, MNthe pilot's failure to maintain clearance with the wire. A factor associated with the accident was the wire which the helicopter contacted.NTSB CHI98LA196Accident · No injuriesLimited investigationFinal reportCessna 172K · Omaha, NEThe aircraft modification not being in compliance with the Supplemental Type Certificate. A factor to the accident was the fracture of the landing gear axle during landing.NTSB CHI98LA195Accident · No injuriesLimited investigationFinal reportCessna 172E · Demotte, INThe pilot's inadequate preflight planning that failed to ensure takeoff could be attained. Other related factors were the aborted takeoff, grass, and a dirt bank.NTSB ANC98LA070Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are wind gusts, and a crosswind condition.NTSB SEA98LA091Accident · 1 fatalLimited investigationFinal reportStephens Vortex · Chinook, MTThe pilot's failure to maintain aircraft control for an undetermined reason.NTSB SEA98FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Hillsboro, ORImproper installation (bushing), mechanical binding (bushing), mechanical binding (connecting rod), and fatigue within the crankshaft. Contributing factors were inadequate major (engine) overhaul and trees.NTSB CHI98LA194Accident · Serious injuriesLimited investigationFinal reportLeone Smith Mini Plane · Northport, MIthe pilot's not maintaining airspeed, and his lack of total experience in this type of aircraft.NTSB ANC98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Anchorage, AKThe pilot's inadvertent ground loop.NTSB ANC98LA067Accident · No injuriesLimited investigationFinal reportCessna 185 · Chickaloon, AKThe pilot's inadvertent activation of the fuel boost pump selector switch during final approach, which resulted in an overly rich mixture and subsequent loss of engine power.NTSB ANC98FA069Accident · No injuriesField investigationFinal reportCessna 207A · Juneau, AKThe failure of company maintenance personnel to properly install a wire bundle clamp; chafing, electrical arcing, and subsequent leaking of a fuel line, which resulted in an in-flight fire. A factor associated with the accident was company maintenance…NTSB MIA98LA180Accident · No injuriesLimited investigationFinal reportRobert E. Bean Wittman Tailwind W10 · Daytona Beach, FLThe pilot's poorly planned approach for not planning the intended touchdown point farther down the runway to avoid an area of known turbulence caused by terrain. Contributing to the accident was the turbulence.NTSB LAX98LA193Accident · No injuriesLimited investigationFinal reportSaab-Scania 91B · Redding, CAThe failure of the pilot to maintain control of the aircraft during an aborted takeoff, which resulted in a ground loop. A factor is the pilot's improper use of carburetor heat during takeoff.NTSB LAX98LA190Accident · No injuriesLimited investigationFinal reportFones Z-MAX 1300 · Buckeye, AZthe failure of the pilot to maintain control of the aircraft during the landing approach, and his poor in-flight planning in making an off-airport landing at an unsuitable landing area.NTSB LAX98FA189Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Lytle Creek, CAthe pilot's intentional VFR descent into instrument meteorological conditions, resulting in a collision with mountainous terrain.NTSB LAX98FA188Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Bangor, CAThe pilot's attempted flight into instrument meteorological conditions, loss of spatial orientation, and the resultant loss of airplane control. Contributing factors were his improper preflight and in-flight decisions, overconfidence in his personal ability,…NTSB ANC98LA066Accident · No injuriesLimited investigationFinal reportCessna 188B · Talkeetna, AKThe pilot's failure to identify an unsafe/hazardous taxiway condition. A factor associated with this accident was the presence of rough and uneven terrain conditions.NTSB SEA98FA089Accident · 1 fatalField investigationFinal reportMooney M20A · Canyon Creek, MTThe design stress limits of the aircraft was exceeded. The pilot's inadequate preflight planning/preparation, lack of an instrument rating, poor weather evaluation and low ceilings and mountain obscuration were factors.NTSB MIA98WA183Accident · No injuriesForeign investigationAero Commander 681 · Fresh Creek, Congo - Kinshasa