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 LAX05LA109Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Half Moon Bay, CAThe pilot's excessive braking during taxi that resulted in the right brake overheating and a fire. A factor in the accident was the pilot's continued operation with known deficiencies.NTSB LAX05FA108Accident · No injuriesField investigationFinal reportCessna 210L · Oxnard, CAA pinhole leak in the fuel pressure line during the takeoff roll that was ignited by an electrical arc associated with wires adjacent to the fuel line. A contributing factor in the accident was the failure of maintenance personnel to comply with a…NTSB DFW05LA083Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Austin, TXThe loss of engine power due to the failure of the number three connecting rod. Contributing factors were the foreign object located within the engine lubrication system, inadequate inspection of the engine by other maintenance personal, and the lack of…NTSB DFW05FA082Accident · 1 fatalField investigationFinal reportCessna 172F · Hot Springs, ARA loss of engine power due to the pilot's failure to refuel resulting in fuel starvation. Contributing factors were the lack of suitable terrain for the forced landing, and a shoulder harness restraint system was not installed.NTSB MIA05LA071Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Merritt Island, FLThe owner/pilot/mechanics inadequate installation of a fuel line resulting in a fuel leak, partial loss of engine power, and force landing in swampy terrain.NTSB LAX05WA107Accident · 1 fatalForeign investigationCessna 310R · Tamworth, AustraliaNTSB DFW05LA080Accident · Minor injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Shreveport, LAThe pilot's misjudgment of airspeed and his failure to abort the landing resulting in an overrun. A contributing factor was the wet runway.NTSB ANC05LA046Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Talkeetna, AKAerodynamic flutter of the ailerons during normal cruise flight due to their improper maintenance/balancing, which resulted in structural damage to the airplane's wings.NTSB ANC05CA047Accident · No injuriesData collectionFinal reportCessna 172B · South Naknek, AKThe pilot's inadequate compensation for wind conditions during taxi after landing, which resulted in the airplane nosing over. A factor associated with the accident was the gusty wind condition.NTSB SEA05LA054Accident · 1 fatalLimited investigationFinal reportSimpkins RV-6A · Yamhill, ORThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in a nose over. Factors contributing to the accident included the wet runway and the embankment.NTSB SEA05CA055Accident · Minor injuriesData collectionFinal reportCessna 172H · Waldport, ORThe pilot's failure to attain sufficient altitude/clearance during the takeoff initial climb, which resulted in an inflight collision with trees. A factor was the tall grass on the turf runway, which slowed the airplane's acceleration during the takeoff roll.NTSB NYC05FA053Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Coatesville, PAThe pilot's inadequate remedial action during an engine failure, which resulted in a loss of airplane control. A factor was the pilot's improper fuel management, which resulted in fuel starvation to one engine, and its subsequent loss of engine power.NTSB MIA05CA072Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Opa Locka, FLThe dual student's improper descent rate during a simulated engine failure and simulated forced landing and the CFI's inadequate remedial action which resulted in a hard landing.NTSB IAD05LA044Accident · Serious injuriesLimited investigationFinal reportBoeing 757-232 · Boston, MAThe first officer's misjudgment of a perceived threat, which resulted in the captain's excessive braking and subsequent injury to a flight attendant. A factor was the night lighting conditions.NTSB IAD05LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Princeton, KYA loss of engine power for undetermined reasons over unsuitable terrain.NTSB DCA05RA041Accident · No injuriesForeign investigationAirbus A310 · Veradero, CubaNTSB CHI05LA076Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Rochester, MNThe loss of engine power due to oil starvation and the subsequent failure of a connecting rod. Additional causes were the improper maintenance due to under-torqued fasteners, and inadequate airframe manufacturer maintenance procedures resulting in an improper…NTSB ATL05CA059Accident · No injuriesData collectionFinal reportEcker Starduster 1 · Millington, TNThe malfunction of the left main landing gear wheel brake during landing roll on a grassy area, resulting in a nose over.NTSB ATL05CA058Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Suches, GAThe pilot's premature liftoff and failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall/mush to the runway and subsequent collision with a fence during aborted takeoff.NTSB ATL05CA057Accident · No injuriesData collectionFinal reportLuscombe 8A · Lexington, NCThe pilot's excessive braking during landing roll, which resulted in a nose-over. A factor was the tailwind.NTSB MIA05LA070Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Destin, FLThe pilot's inadequate compensation for wind during a crosswind takeoff resulting in a loss of directional control and subsequent collision with terrain.NTSB MIA05CA074Accident · No injuriesData collectionFinal reportDgflugzeugbau DG-800S · Clermont, FLThe pilots failure to maintain airspeed which resulted in the glider stalling and impact with trees during the uncontrolled descent.NTSB IAD05LA042Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Andover, NJThe pilot receiving instruction's failure to maintain directional control during the landing roll. Factors in the accident were the flight instructors delayed remedial action, and crosswind.NTSB DFW05LA081Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Westport, OKThe collapsing of the right main landing gear as a result of the failure of the scissors assembly.NTSB ATL05CA056Accident · Minor injuriesData collectionFinal reportBellanca 17-30A · Eagleville, TNThe pilot's mismanagement of the fuel supply by his failure to switch the fuel selector position , which resulted in a loss of engine power due to fuel starvation.NTSB SEA05WA053Accident · 6 fatalForeign investigationCessna 340A · Bologna, ItalyNTSB MIA05CA067Accident · No injuriesData collectionFinal reportCessna 172 · Jacksonville, FLThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL05TA055Accident · Serious injuriesFinal reportCessna T-41B · Sparta, TNImproper installation of the timing reference plug by other maintenance personnel, which resulted in oil starvation, and the loss of engine power.NTSB NYC05FA054Accident · No injuriesField investigationFinal reportBoeing 777-200 · Newark, NJThe captain's failure to follow company procedures, which resulted in a tail strike. Contributing were the gusty crosswind and tailwind conditions, and the manufacturer's failure to provide adequate performance planning data to account for gusty crosswinds…NTSB MIA05LA066Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe improper installation and securing of the elevator trim tab push-rod attaching hardware by maintenance personal resulting in the rod disconnecting and a partial separation of the right elevator in flight.NTSB MIA05CA068Accident · No injuriesData collectionFinal reportCessna 305A · Bartow, FLThe pilots failure to maintain directional control resulting in the airplane ground-looping. A factor in the accident was the pilots lack of total experience in the airplane make and model.NTSB MIA05CA065Accident · No injuriesData collectionFinal reportCessna 172 · Madison, MSThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.NTSB DFW05CA079Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Dumas, ARThe pilot's failure to maintain clearance from the power lines.NTSB ANC05FA039Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Dunnellon, FLThe improper installation of the bolt that connects the throttle linkage to the fuel control arm by an unknown maintenance person, which resulted in a loss of the bolt, a loss of engine rpm control, and subsequent forced landing and collision with trees.NTSB ANC05CA040Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Panama City, FLThe pilot's failure to remove frost from the airplane which resulted in an inadvertent stall/mush during the takeoff/initial climb, and an in-flight collision with trees. Contributing to the accident were the rough and uneven airstrip, and degraded aircraft…NTSB LAX05FA106Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Yucaipa, CAThe failure of the private pilot and the flight instructor to maintain adequate terrain clearance while flying in unfamiliar mountainous terrain in dark night conditions.NTSB DEN05LA060Accident · 2 fatalLimited investigationFinal reportPiel Emeraude CP-305 · Del Norte, COThe pilot's failure to maintain clearance with the terrain for undetermined reasons.NTSB ANC05LA045Accident · No injuriesLimited investigationFinal reportHelio H-295 · Fairbanks, AKThe pilot's delay in performing a go-around, and his failure to maintain obstacle clearance.NTSB ANC05FA038Accident · Serious injuriesField investigationFinal reportAero Commander 500-S · San Juan, PRThe fuel truck operator's improper refueling of a gasoline engine powered airplane with jet (turbine) fuel, and the pilot's inadequate preflight, which resulted in a loss of power in both engines and subsequent collision with trees. Factors associated with…NTSB LAX05CA104Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Williams, AZthe pilot's improper ground handling procedure and failure to ensure the magnetos were off prior to movement of the propeller.NTSB IAD05FA040Accident · 2 fatalField investigationFinal reportCessna 182P · West Milford, NJThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel ice, during the initial climb after takeoff.NTSB ANC05LA044Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot's excessive taxi speed during a turn while taxiing from landing, which resulted in the collapse of the left main landing gear, and structural damage to the fuselage.NTSB DEN05LA059Accident · 1 fatalLimited investigationFinal reportBourgeois-Avid Flyer MK IV · Kaycee, WYthe pilot's failure to maintain airspeed which resulted in a stall.NTSB CHI05CA075Accident · Serious injuriesData collectionFinal reportCessna 172K · Portage, WIThe pilot's failure to maintain adequate airspeed during the aborted landing, which resulted in an inadvertent stall at a low altitude. Factors to the accident were the pilot's lack of experience flying from the right pilot station and his failure to maintain…NTSB CHI05CA074Accident · Serious injuriesData collectionFinal reportCessna 177RG · Fargo, NDThe mechanic's improper installation of the oil filter canister base gasket, which resulted in an oil leak and the separation of the connecting rod due to oil starvation. Factors to the accident were the unsuitable terrain encountered during the forced…NTSB ATL05CA053Accident · Serious injuriesData collectionFinal reportBennett Ra Oliver Zodiac CH 601 HDS · Mt. Olive, NCRupture of the engine's cooling system radiator, which allowed steam to fill the cockpit.NTSB ANC05LA043Accident · No injuriesLimited investigationFinal reportCessna 185 · Russian Mission, AKThe pilot's misjudged landing flare during landing, which resulted in a hard landing and structural damage to the fuselage when the left main landing gear collapsed. A factor associated with the accident is pressure placed upon the pilot by the…NTSB DFW05CA094Accident · No injuriesData collectionFinal reportGrumman G-164A · Tuckerman, ARThe loss of engine power as result of the failure of the number nine cylinder.NTSB CHI05LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Macon, MOThe loss of engine power due to failure of the engine exhaust valve. The pilot's inability to maintain clearance from obstacles, the trees, the residence and the pilot's evasive maneuver were factors in the accident.NTSB DFW05WA078Accident · 7 fatalForeign investigationIsrael Aircraft Industries Westwind 1124 · Sapotito, Mexico