NTSB investigations
19,222 cases where NTSB found Aircraft.
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 WHERE c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01')) 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 WHERE c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01')) 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 GAA18CA143Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot’s improper approach and landing flare, which resulted in a porpoised landing.NTSB ERA18LA068Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Fort Lauderdale, FLThe partial loss of engine power during the initial climb due to a stuck intake valve on the No. 4 cylinder.NTSB CEN18LA085Accident · No injuriesLimited investigationFinal reportQuartz Mountain Aerospace L-11E · Omaha, NEThe instructor pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB ANC18LA025Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC 2 · Kodiak, AKThe pilot's failure to maintain directional control during landing for reasons that could not be determined based on the available evidence.NTSB GAA18CA110Accident · Minor injuriesData collectionFinal reportHelicopteres Guimbal Cabri G2 · Cahokia, ILThe student pilot's failure to maintain yaw control while landing in gusting crosswind conditions and the flight instructor's delayed remedial action.NTSB ERA18FA064Accident · 1 fatalField investigationFinal reportVans RV-12 · Bonita Springs, FLThe pilot's unsafe maneuvering and exceedance of the airplane's operating limitations, which resulted in an in-flight failure of the left wing. Contributing to the accident was the pilot's underlying physiologic or psychiatric disease.NTSB CEN18LA084Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Abilene, TXMaintenance personnel’s improper maintenance of the engine, which resulted in a catastrophic engine failure due the shifting/slipping of the No. 2 bearing and the subsequent oil starvation and total loss of engine power during cruise flight.NTSB GAA18CA115Accident · No injuriesData collectionFinal reportCessna 210 · Sussex, NJThe pilot’s inadvertent landing gear retraction during approach.NTSB ERA18LA082Accident · Serious injuriesLimited investigationFinal reportMosquito XEL · Loxahatchee, FLThe noncertificated pilot's failure to maintain helicopter control during takeoff. Contributing to the accident were the pilot's lack of recent flight experience and his lack of training and experience in the accident helicopter make and model.NTSB ERA18LA067Accident · No injuriesLimited investigationFinal reportCessna 172RG · Martinsburg, WVA hydraulic leak in the right main landing gear actuator, which resulted in the main landing gear not extending.NTSB CEN18LA082Accident · Serious injuriesLimited investigationFinal reportMatheny Larry E Christavia MK 1 · Grand Detour, ILThe pilot's failure to see and avoid the power line. Contributing to the accident was the pilot’s intentional flight at low altitude.NTSB CEN18LA086Accident · No injuriesLimited investigationFinal reportSwearingen SA227 TT · Houston, TXThe failure of the left starter relay during engine start, which resulted in a loss of electrical and battery power during the flight and led to a forced landing with the nose landing gear not fully extended, causing substantial damage to the engines.NTSB CEN18LA080Accident · Minor injuriesLimited investigationFinal reportTomlinson Tracy L Tukan · Erie, COThe student pilot’s inadvertent shutting off of the fuel valve while on approach, which resulted in a loss of engine power due to fuel starvation and impact with terrain.NTSB CEN18FA078Accident · 5 fatalField investigationFinal reportBell UH-1H · Raton, NMThe pilot's failure to maintain adequate altitude above mountainous terrain during cruise flight in dark night conditions, which resulted in controlled flight into terrain.NTSB WPR18LA070Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Reno, NVA total loss of engine power due to fuel starvation. Contributing to the accident was the failure of the pilot/owner to ensure that the airplane was airworthy before flight.NTSB WPR18LA069Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Skyforest, CAThe pilot’s failure to establish the proper airspeed after departure and to maintain adequate clearance from a ridgeline in high-density and downdraft conditions and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an…NTSB GAA18CA109Accident · No injuriesData collectionFinal reportBeech B60 · Scottsdale, AZThe pilot’s improper brake application during landing, which resulted in a tire blowout and a loss of directional control.NTSB CEN18LA077Accident · Serious injuriesClass 3 · LimitedFinal reportBryk Steven L Velocity XL RG · Santa Fe, NMThe airplane’s inadvertent encounter with unforecasted icing conditions during cruise flight, which resulted in the accumulation of airframe icing, the airplane’s inability to maintain altitude, and a subsequent forced landing on rough terrain.NTSB GAA18CA104Accident · Minor injuriesData collectionFinal reportGeldermann Bert E Lancair Legacy · Friday Harbor, WAThe pilot’s inability to maintain the landing flare, which resulted in the airplane landing hard short of the runway. Contributing to the accident was the cockpit canopy opening in flight.NTSB CEN18FA074Accident · 2 fatalField investigationFinal reportMD Helicopters 369HM · Perrysburg, OHA loss of engine power due to snow or ice ingestion at an altitude that was insufficient to allow for engine re-ignition. Contributing to the accident were conditions, including altitude and flat light conditions, that precluded a successful autorotation to…NTSB GAA18CA103Accident · Minor injuriesData collectionFinal reportHarrop Blake RV 7 · Death Valley National Park, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.NTSB ANC18LA019Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Juneau, AKA loss of hydraulic fluid due to a fatigue failure of the right main landing gear hydraulic actuator, which resulted in the pilot's inability to fully extend the landing gear and a main landing gear collapse during the landing roll.NTSB WPR18LA065Accident · No injuriesLimited investigationFinal reportJust JA30 Superstol · Kapolei, HIThe collapse and separation of the right landing gear suspension strut due to overload.NTSB GAA18CA108Accident · No injuriesData collectionFinal reportPiper J3L · Astoria, ORThe control stick handgrip separation from the control stick resulting in the airplane pitching forward, which resulted in hard landing.NTSB CEN18LA079Accident · No injuriesLimited investigationFinal reportDayton A Dabbs Magni M-16 · Point Venture, TXThe loss of engine power for reasons that could not be determined because a postaccident engine test run showed no anomalies that would have precluded normal operation, and the pilot's decision to conduct the flight at a low altitude.NTSB CEN18LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-236 · Tishomingo, OKThe pilot’s inadequate preflight fuel planning and in-flight fuel monitoring and his decision to take off with an unverified amount of fuel, which resulted in fuel exhaustion and a subsequent impact with trees during an attempted forced landing.NTSB WPR18FA073Accident · 1 fatalField investigationFinal reportPiper PA 23-250 · Elko, NVThe pilot's inadequate preflight weather planning, which resulted in the flight over mountainous terrain into forecast instrument meteorological conditions, icing, and mountain wave, and resulted in an uncontrolled descent and collision with terrain.NTSB GAA18CA106Accident · No injuriesData collectionFinal reportCessna A185 · Lowman, IDThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of directional control.NTSB GAA18CA101Accident · No injuriesData collectionFinal reportCub Crafters CC18-180 · Winnimucca, NVThe pilot’s failure to maintain directional control and her use of excessive braking during landing, which resulted in a nose-over.NTSB GAA18CA100Accident · No injuriesData collectionFinal reportCessna 170 · Auburn, NYThe pilot’s improper wind correction inputs while taxiing with a quartering tailwind.NTSB GAA18CA099Accident · No injuriesData collectionFinal reportCubcrafters CC11 · Spanish Fork, UTThe pilot’s incorrect brake application during the landing roll, resulting in a nose over.NTSB GAA18CA098Accident · No injuriesData collectionFinal reportSwearingen SA227 · Rock Springs, WYThe pilot's failure to maintain directional control while taxiing in gusting tailwind conditions.NTSB CEN18LA073Accident · No injuriesLimited investigationFinal reportS.O.C.A.T.A. MS893E · Wadsworth, OHThe pilot’s failure to apply carburetor heat during the approach, which resulted in a loss of engine power due to carburetor icing.NTSB GAA18CA116Accident · No injuriesData collectionFinal reportBeech B19 · Meadville, PAThe student pilot’s failure to maintain directional control during landing.NTSB CEN18LA070Accident · No injuriesLimited investigationFinal reportCessna 170 · Ponca City, OKThe pilot's loss of directional control during takeoff with a quartering tailwind, which resulted in a runway excursion.NTSB CEN18CA072Accident · No injuriesData collectionFinal reportBell Helicopter Textron Canada 407 · Norfolk, NEMaintenance personnel’s failure to properly secure the tail rotor drive shaft cover, which resulted in the cover departing the helicopter in flight.NTSB CEN18FA400Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22T · Gulf of Mexico (Gulf of Mexico)The pilot's incapacitation resulted in impact with the Gulf of Mexico. The reason the hypoxia recognition system did not descend the airplane as designed could not be determined as the airplane was not located.NTSB WPR18LA057Accident · No injuriesLimited investigationFinal reportCessna T210L · Aurora, ORA collapse of the right main landing gear during the landing roll because the gear would not lock into place. Contributing to the accident was the pilot's failure to perform the alternate landing gear extension procedure before landing.NTSB ANC18LA018Accident · No injuriesClass 2 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2006 · Lynchburg, VAThe failure of the left main landing gear assembly due to a fatigue fracture along the inside circumferential weld on the trailing arm’s attachment flange, which resulted from the manufacturer’s inadequate welding of the trailing arm connecting the lower arm…NTSB CEN18FA063Accident · 12 fatalField investigationFinal reportCessna 208 · Punta Islita, Costa RicaThe flight crew's failure to maintain airspeed while maneuvering to exit an area of rising terrain, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. Contributing to the accident was the flight crew's…NTSB WPR18LA058Accident · No injuriesLimited investigationFinal reportCessna 210 · San Bernardino, CAThe fatigue failure of the left main landing gear (MLG) saddle, which resulted in the pilot's inability to extend the left MLG. Contributing to the accident was the pilot's improper decision to fly the airplane before the annual inspection was completed and…NTSB WPR18FA063Accident · 2 fatalField investigationFinal reportCessna 172M · Ogden, UTThe pilot's failure to maintain clearance from the water while flying over a lake with glassy surface conditions. Contributing to the accident was the pilot's use of three impairing medications.NTSB CEN18LA064Accident · No injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Paulding, OHThe loss of engine power while the motor-powered glider was maneuvering due to the fuel unporting in its fuel tank, which resulted in fuel starvation and a subsequent forced landing on unsuitable terrain.NTSB GAA18CA096Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox · Upper Lake, CAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the approach to land, which resulted in an aerodynamic stall.NTSB CEN18LA062Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 525A · Michigan City, INThe flight crew's improper decision to land on a snow-covered runway that had insufficient runway distance for the airplane to land with the contamination, which resulted in a runway overrun and impact with obstacles.NTSB WPR18LA056Accident · No injuriesClass 3 · LimitedFinal reportCessna 150L · Perris, CAThe presence of debris in the carburetor and blockage of the fuel delivery system, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the lack of maintenance to the carburetor.NTSB CEN18LA052Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Riverton, WYThe pilot's loss of directional control during the rejected takeoff. Contributing to the accident were the pilot's lack of familiarity with the airport runway configuration, which led to his premature attempt to take off, and the airplane’s inoperative…NTSB ERA18TA059Accident · Minor injuriesFinal reportCessna 172 · Union Mills, NCThe pilot's failure to use carburetor heat in weather conditions conducive to serious carburetor icing, which resulted in a total loss of engine power and a subsequent forced landing.NTSB CEN18FA061Accident · 5 fatalField investigationFinal reportCessna 340 · Bartow, FLThe pilot's loss of control due to spatial disorientation during takeoff in instrument meteorological conditions.NTSB GAA18CA093Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot’s failure to maintain directional control during the landing flare.