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 SEA06CA002Accident · No injuriesData collectionFinal reportBeech D35 · Creswell, ORThe pilot's failure to attain a proper touchdown point and worn brakes. Inadequate maintenance was a factor.NTSB NYC06LA002Accident · Serious injuriesLimited investigationFinal reportEmbraer 170 · Dulles, VAThe flight crew's excessive maneuver in response to a traffic alert during the landing approach.NTSB NYC06CA053Accident · No injuriesData collectionFinal reportBeech E-55 · Providence, RIThe pilot's failure to verify landing gear extension after a landing gear malfunction, which resulted in a wheels up landing.NTSB MIA06LA002Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Destin, FLThe inadequate design of the engine mount which led to cracking of the mount resulting in a loss of directional control and collapse of the nose landing gear. A contributing factor was the failure of maintenance personnel to comply with a service bulletin to…NTSB MIA06LA001Accident · Serious injuriesLimited investigationFinal reportPilatus PC-6/B2-H2 · Deland, FLThe pilot's incorrect setting of the stabilizer trim and his failure to maintain adequate airspeed during takeoff initial climb, which resulted in a stall. A factor contributing to the accident was an inadvertent stall. A factor contributing to the severity…NTSB LAX06CA001Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Tucson, AZthe student pilot's failure to maintain adequate airspeed and rotor rpm during a practice autorotation, and the instructor's failure to adequately monitor the maneuver, which resulted in a hard landing and roll over.NTSB ANC06LA001Accident · No injuriesLimited investigationFinal reportCessna 185 · Iliamna, AKThe pilot's inadequate preflight inspection, which failed to detect water-contaminated fuel, resulting in a loss of engine power during cruise flight, and subsequent in-flight collision with terrain.NTSB WAS06WA001Accident · 4 fatalForeign investigationEurocopter Deutschland BO-105 · Harlem, South AfricaNTSB SEA06CA001Accident · Minor injuriesData collectionFinal reportCessna 150D · Greenwater, WAThe pilot's inadvertently flying into IMC weather conditions, his failure to maintain sufficient airspeed for flight, and his subsequent inadvertent stall/mush into trees. Contributing factors were the fog and the trees.NTSB NYC06CA001Accident · No injuriesData collectionFinal reportWaco YMF · Kensington, NHAn overload fracture of the right main landing gear during the landing roll, which resulted in a nose over.NTSB MIA06CA009Accident · No injuriesData collectionFinal reportCessna 172N · Punta Gorda, FLThe in-flight collision with a bird resulting in substantial damage to the airplane.NTSB LAX06CA002Accident · Serious injuriesData collectionFinal reportBell 206B · Pixley, CAthe pilot's failure to maintain clearance with the wire during a low altitude aerial application flight.NTSB DFW06CA001Accident · No injuriesData collectionFinal reportCessna 195 · Addison, TXThe pilot's failure to maintain directional control while landing. A contributing factor was the wind gusts.NTSB DEN06LA016Accident · Serious injuriesLimited investigationFinal reportAbruzzo Grom-1 · Kendall, KSthe downdraft forcing the balloon into the power lines. A contrbuting factor was the clear air turbulence and the power lines.NTSB SEA06LA003Accident · No injuriesLimited investigationFinal reportBeech B-60 · Arlington, WAMain landing gear collapse during the landing rollout for undetermined reasons.NTSB LAX05CA322Accident · No injuriesData collectionFinal reportCessna 172P · Reno, NVthe pilot's failure to maintain control of the airplane while taxiing in gusty wind conditions.NTSB DFW05FA251Accident · 2 fatalField investigationFinal reportCessna 150M · Crystal Springs, MSThe pilot's failure to retract the flaps during the go-around and his failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the dark night conditions.NTSB ATL06CA001Accident · Minor injuriesData collectionFinal reportBeech D-95A · Greensboro, NCThe pilot mistakenly shut down the operating engine when the passenger interfered with the rudder pedals as he attempted to identify the inoperative engine.NTSB ANC05CA151Accident · No injuriesData collectionFinal reportCessna 182 · Bethel, AKThe pilot's misjudged distance and speed, which resulted in an overrun and a nose over during the landing roll. A factor associated with the accident was the dusk lighting conditions.NTSB SEA05MA202Accident · 3 fatalMajor investigationFinal reportAgusta A109A II · Edmonds, WALoss of control for an undetermined reason during maneuvering flight, which resulted in an in-flight collision with water.NTSB MIA05WA165Accident · 1 fatalForeign investigationCessna 182 · Barinas, VenezuelaNTSB MIA05LA164Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Arcadia, FLA loss of engine power due to the failure of the master rod bearing.NTSB IAD05LA144Accident · Serious injuriesLimited investigationFinal reportHoward Whyte Nieuport 28 · Dayton, OHA loss of engine power due to the installation of incorrect spring type terminal contacts which were accidentally supplied by the engine distributor.NTSB DEN05LA150Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Longmont, COthe failure of the left rudder cable resulting in a loss of directional control by the pilot. Contributing to the accident was the improper repair procedures on the seat frame.NTSB CHI05LA276Accident · 1 fatalLimited investigationFinal reportStits Playboy SA3B Lightning · Kimball, NEThe inadvertent stall and low airspeed by the pilot following takeoff. Contributing factors were the low altitude at the time of occurrence, the high density altitude, and the propeller.NTSB ATL05CA165Accident · No injuriesData collectionFinal reportCessna C172F · Sparta, TNThe pilot's delay in applying carburetor heat that resulted in the loss of engine power due to carburetor ice.NTSB ANC05LA150Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Ft Yukon, AKThe pilot's improper use of anti-icing equipment during cruise flight, which resulted in ice ingestion into both engines (foreign object damage), the complete loss of engine power in both engines, and an emergency descent and landing on tree covered terrain.…NTSB LAX05CA320Accident · No injuriesData collectionFinal reportAeronca 7AC · Snelling, CAthe loss of engine power for undetermined reasons.NTSB DFW05CA253Accident · No injuriesData collectionFinal reportCessna 172S · Batesville, TXThe pilot's failure to maintain clearance from the tree. A contributing factor was the gusty winds.NTSB SEA05FA201Accident · 2 fatalField investigationFinal reportCessna P210N · Salmon, IDThe pilot's failure to obtain airspeed during the initial takeoff climb, which resulted in a stall/mush and subsequent collision with terrain.NTSB LAX05LA321Accident · 1 fatalLimited investigationFinal reportCessna 150 · Taft, CAThe pilot's failure to maintain terrain clearance while maneuvering. The mountainous terrain was a factor.NTSB DEN05CA149Accident · No injuriesData collectionFinal reportCessna 206 · Brigham City, UTthe pilot's improper in-flight planning and decision making and failure to maintain aircraft control during the ground roll.. Contributing to the accident was the soft dirt.NTSB ATL05CA164Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Guyton, GAThe pilot's improper recovery from a bounced landing, and improper flare, which resulted in a hard landing.NTSB SEA05WA203Accident · 2 fatalForeign investigationHughes 269C · Daisen, JapanNTSB MIA05WA162Accident · 1 fatalForeign investigationPiper PA-36-375 · Puerta del Segu, SpainNTSB LAX05LA319Accident · Minor injuriesLimited investigationFinal reportRose Kitfox · Hesperia, CAa loss of engine power due to a loose master ignition relay wire.NTSB CHI05CA275Accident · No injuriesData collectionFinal reportCessna T206H · Sturgeon Bay, WIThe unexpected wave that the airplane encountered during the landing flare.NTSB MIA05CA161Accident · Minor injuriesData collectionFinal reportVans RV-3 · Bell, FLThe pilot's failure to maintain visual lookout during a VFR approach toward the runway resulting in-flight collision with trees. Factors in this accident are no lights for the grass strip runway and attempting to land in low natural light visibility…NTSB LAX05LA318Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pioche, NVcontrolled flight into mountainous terrain due to the pilot's inadequate preflight planning and preparation and his inadequate in-flight decisions, which created a low fuel state emergency situation that led directly to the CFIT during flight assist efforts…NTSB LAX05LA317Accident · No injuriesLimited investigationFinal reportCessna A185F · Tracy, CAloss of engine power for undetermined reasons.NTSB DFW05WA254Accident · 1 fatalForeign investigationBell UH-1H · Pisa Flores, MexicoNTSB CHI05LA277Accident · No injuriesLimited investigationFinal reportCessna 560XL · Columbus, OHThe collapse of the nose landing gear for undetermined reasons.NTSB NYC05CA147Accident · No injuriesData collectionFinal reportCessna 182 · Southampton, NYThe pilot's failure to maintain directional control while landing.NTSB MIA05CA163Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Opa Locka, FLThe pilot's failure to maintain airspeed, during a banner pick up, resulting in a stall/mush and collision with terrain during the uncontrolled descent.NTSB IAD05CA148Accident · No injuriesData collectionFinal reportSchweizer SGS-2-33A · Windsor, VAThe solo student pilot's loss of control during landing.NTSB SEA05MA199Accident · 3 fatalClass 1 · MajorFinal reportAerospatiale AS350BA · Haena, HIThe pilot's decision to continue flight into adverse weather conditions, which resulted in a loss of control due to an encounter with a microburst. Contributing to the accident was inadequate Federal Aviation Administration surveillance of Special Federal…NTSB SEA05CA200Accident · Minor injuriesData collectionFinal reportMcDonnell Douglas 369E · Medford, ORIn-flight collision with terrain during a precautionary landing. Factors include instrument meteorological conditions and pilot disorientation.NTSB LAX05WA323Accident · 2 fatalForeign investigationBeech A36 · Tenterfield, NS, AustraliaNTSB IAD05LA142Accident · 2 fatalLimited investigationFinal reportAir Creation Clipper 912 · Millstone, NJThe pilot's failure to maintain control of the airplane, which resulted in an uncontrolled descent and impact with trees.NTSB IAD05CA141Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 77A · Louisville, KYThe ground crewman's failure to release the basket of the balloon when it resumed flight during the landing phase. A factor in the accident was the wet grass at the landing site.