NTSB investigations
3,633 cases where NTSB found Aircraft systems.
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\", '0102')) 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", '0102')) 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 GAA18CA531Accident · No injuriesData collectionFinal reportPiper PA44 · Centralia, ILThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended before landing. Contributing to the accident was the flight instructor’s delayed remedial action and…NTSB GAA18CA557Accident · No injuriesData collectionFinal reportSchweizer SGS 1 35 · Burnet, TXThe pilot's failure to extend the landing gear before landing and to use the Before Landing checklist.NTSB CEN18LA360Accident · No injuriesLimited investigationFinal reportStearman A75N1(PT17) · Kenosha, WIThe failed retaining bolt and cracked backing plate, which resulted in a shift of the brake lining to contact the brake drum and a subsequent wheel lock when the brakes were applied.NTSB WPR18FA244Accident · 1 fatalField investigationFinal reportCessna 150 · Redding, CAThe pilot's exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was the pilot's failure to properly configure the wing flaps for…NTSB CEN18LA352Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Rushville, INLoss of engine power due to carburetor icing and the pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.NTSB GAA18CA511Accident · No injuriesData collectionFinal reportMooney M20J · Rochester, NHThe pilot’s failure to maintain directional control during takeoff.NTSB WPR18LA242Accident · Serious injuriesClass 3 · LimitedFinal reportBell 212 · Dardanelle, CAAn in-flight failure of the trunnion bearing and subsequent failure of the drive link and swashplate support, which resulted in the loss of helicopter control.NTSB GAA18CA540Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · East Stroudsburg, PAThe pilot's failure to extend the landing gear during landing, which resulted in a runway excursion and subsequent impact with terrain.NTSB GAA18CA516Accident · No injuriesData collectionFinal reportPiper PA28 · Point Lookout, MOThe student pilot's inadvertent left brake application during the landing roll, which resulted in a runway excursion and collision with runway lights.NTSB CEN18LA349Accident · Serious injuriesLimited investigationFinal reportNorth American T-28B · Minneapolis, MNThe fire during approach for reasons that could not be determined based on the available evidence, which resulted in impact with terrain during approach for a precautionary landing.NTSB CEN18LA348Accident · No injuriesLimited investigationFinal reportPiper PA32R · Falcon, COThe pilot's decision to depart with an inoperative left magneto, which resulted in degraded climb performance in high-density altitude conditions and a subsequent emergency landing.NTSB GAA18CA503Accident · Minor injuriesData collectionFinal reportChampion 8GCBC · Elberta, ALThe pilot's failure to use carburetor heat during a low-power setting approach in conditions conducive to carburetor icing, which resulted in a partial loss of engine power.NTSB GAA18CA501Accident · No injuriesData collectionFinal reportCessna A185 · McCall, IDThe disconnection of the brake cylinder actuator rod, which resulted in the pilot’s inability to maintain directional control during the landing roll.NTSB CEN18LA345Accident · No injuriesLimited investigationFinal reportCessna T210 · Tulsa, OKThe pilot's decision to take off with a known electrical problem, which resulted in the loss of electrical power, problem with the landing gear extension system, and subsequent runway excursion.NTSB CEN18LA344Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Addison, TXThe pilot's improper flap setting for takeoff and subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing was the overgross state of the airplane.NTSB ANC18LA067Accident · No injuriesLimited investigationFinal reportCessna U206 · Pedro Bay, AKThe fatigue fracture of both main landing gear legs during the landing roll, which resulted in the collapse and separation of both main landing gear legs.NTSB CEN18FA336Accident · 1 fatalField investigationFinal reportCessna 172 · Rhome, TXThe pilot's inadequate maintenance of the airplane, which resulted in a total loss of engine power due to fuel starvation when organic debris restricted available fuel to the carburetor, and the pilot's impairment due to the ingestion of alcohol, which…NTSB ERA18LA220Accident · No injuriesLimited investigationFinal reportCzech Sport Piper Sport · Stuart, FLInadequate maintenance inspection of the airplane's nose landing gear, which resulted in a nose landing gear collapse during landing due to cracking and corrosion.NTSB DCA18CA283Accident · No injuriesClass 4 · Data collectionFinal reportAirbus A321-271N · Los Angeles, CAa tailstrike caused by inappropriate recovery technique after a bounced landing. Contributing to the accident was the failure of the radio altimeter, caused by the approach being over calm/flat water, that was not recognized by the flight crew.NTSB CEN18TA330Accident · No injuriesFinal reportPiper J3C · Friendswood, TXThe pilot's decision to conduct a flight in an airplane that had a tailwheel with degraded locking pins, which allowed the tailwheel to unlock and swivel out of alignment and precluded the pilot from regaining directional control on the ground during a…NTSB ERA18LA214Accident · No injuriesClass 3 · LimitedFinal reportPipistrel Sinus 912 · West Palm Beach, FLThe fatigue failure of the exhaust system manifold, which resulted in a ground fire after landing.NTSB WPR18FA218Accident · 2 fatalField investigationFinal reportMooney M20K · Baker City, ORThe pilot's exceedance of the airplane's critical angle of attack during the landing approach as a result of his diversion of attention after a series of non-essential aircraft systems became inoperative following the failure of the engine-driven vacuum pump,…NTSB WPR18LA215Accident · No injuriesLimited investigationFinal reportCessna T337 · Lewiston, IDThe liberation of an internal snap ring from a landing gear door actuator, which resulted in a complete loss of hydraulic fluid and a gear-up landing. Contributing to the accident was the failure of maintenance personnel to replace the snap ring during the…NTSB ERA18LA215Accident · No injuriesLimited investigationFinal reportCessna R182 · Florence, SCThe pilot's failure to comply with emergency procedures in the pilot's operating handbook, resulting in the collapse of the main landing gear during landing. Contributing to the accident was the pilot's failure to address the low battery voltage before…NTSB GAA18CA472Accident · Minor injuriesData collectionFinal reportCessna 140 · Mount Holly, NJThe pilot's improper landing flare, which resulted in the airplane ballooning upon landing, and his subsequent loss of directional control and excessive brake application.NTSB ERA18LA210Accident · Minor injuriesClass 3 · LimitedFinal reportChampion 7GCAA · Lakewood, NJThe pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power due to the formation of carburetor ice, a forced landing and impact with terrain.NTSB CEN18LA315Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Dallas, TXThe pilot's inability to maintain directional control during taxi due to excessively worn brake pads and a deflated right main tire.NTSB GAA18CA459Accident · No injuriesData collectionFinal reportHerzog CCX-2000 · Bend, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and the subsequent collapse of the left main landing gear when he attempted to steer the airplane back onto the runway.NTSB CEN18LA302Accident · No injuriesLimited investigationFinal reportBeech A36 · Brainerd, MNTotal loss of engine power due to a fuel supply interruption from the left tank for reasons that could not be determined, which resulted in the subsequent forced landing into trees.NTSB GAA18CA462Accident · No injuriesData collectionFinal reportPiper PA24 · Evanston, WYThe pilot's failure to extend the landing gear during landing. Contributing to the accident were the pilot's distraction and his failure to complete the appropriate checklist before landing.NTSB CEN18LA300Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat MK5A · Le Sueur, MNThe pilot's inadequate preflight and in-flight fuel planning, during which he did not visually check the fuel quantity in the fuel tanks and instead relied on the fuel gauges that were showing erroneous fuel quantity indications, which resulted in fuel…NTSB GAA18CA455Accident · No injuriesData collectionFinal reportCessna 140 · Healdsburg, CAThe pilot's improper brake application during the landing roll, which resulted in a nose-over.NTSB ERA18TA203Accident · No injuriesFinal reportBeech C90 · Lecanto, FLThe pilot's failure to turn on the fuel transfer pumps in accordance with the published checklists, which resulted in a dual loss of engine power due to fuel starvation.NTSB ERA18LA201Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 560 · Crestview, FLA collapse of the right main landing gear for reasons that could not be determined based on the available information.NTSB GAA18CA454Accident · No injuriesData collectionFinal reportCessna 172 · Meadow Lakes, AKThe pilot’s selection of the wrong fuel tank for departure, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB CEN18LA295Accident · Serious injuriesLimited investigationFinal reportVans RV7A · Princeton, MNA flat nosewheel tire, which resulted in the pilot’s inability to maintain directional control on landing.NTSB GAA18CA438Accident · No injuriesData collectionFinal reportMooney M20E · Great Falls, MTThe flight instructor’s incorrect use of the landing gear system and his and the pilot’s failure to ensure that the landing gear was extended, which resulted in a gear-up landing. Contributing to the accident was the flight instructor’s unfamiliarity with the…NTSB CEN18LA285Accident · No injuriesLimited investigationFinal reportSmith AEROSTAR601 · Baton Rouge, LAThe loss of right engine power due to fuel starvation, which resulted from corrosion debris in the fuel lines. Contributing to the accident was the mechanic’s and pilot’s inadequate maintenance of the airplane before the flight.NTSB GAA18CA432Accident · No injuriesData collectionFinal reportPiper PA28 · Oregon, WIThe pilot's improper decision to take off with a known brake malfunction, which resulted in a collision with a barn during landing on a wet runway.NTSB CEN18LA271Accident · No injuriesLimited investigationFinal reportSteen Skybolt · Lexington, TXThe fatigue failure of the main landing gear (MLG) truss, which resulted in the MLG spreading apart.NTSB ERA18LA191Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Geneseo, NYThe pilot's failure to properly set the elevator trim before takeoff, which resulted in an exceedance of the airplane's critical angle of attack during takeoff and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s failure to follow…NTSB GAA18CA418Accident · No injuriesData collectionFinal reportPiper PA28R · Houston, TXThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to ensure that the landing gear were extended during landing. Contributing to the accident was the pilot receiving instruction's and instructor's failure…NTSB CEN18LA260Accident · No injuriesLimited investigationFinal reportBell 206 · Bentley, ILThe pilot's failure to ensure that adequate fuel was on board for the maneuvering flight, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA18CA397Accident · Minor injuriesData collectionFinal reportRobert Miles Smith Trike · Lewiston, ILA total loss of engine power due to the pilot's failure to apply carburetor heat in conditions conducive to carburetor icing and his subsequent failure to maintain directional control during a forced landing.NTSB ERA18LA226Accident · No injuriesLimited investigationFinal reportPiper PA28 · Thomaston, GAA landing gear axle nut being pulled from the threads of the axle rod at an unknown time, which resulted in the pilot's inability to maintain directional control during landing.NTSB CEN18LA250Accident · No injuriesLimited investigationFinal reportCessna 180 · Lago Vista, TXThe separation of the left main landing gear spring during landing due to a preexisting fatigue crack.NTSB GAA18CA407Accident · No injuriesData collectionFinal reportBeech 58 · Mackinac Island, MIThe pilot’s failure to remove the pitot tube cover during the preflight inspection, which resulted in his delayed decision to reject the takeoff with insufficient runway remaining to safely stop the airplane.NTSB ERA18LA182Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 25 · Flat Rock, ALThe failure of the right landing gear during takeoff due to a fatigue failure, which resulted in a runway excursion.NTSB CEN18LA246Accident · No injuriesLimited investigationFinal reportCessna 337 · Baldwin City, KSThe loss of hydraulic accumulator pressure for reasons that could not be determined, which prevented the propeller from unfeathering, and the pilot's improper decision to attempt a go-around, which resulted in an off-airport landing and the airplane impacting…NTSB GAA18CA412Accident · No injuriesData collectionFinal reportBeech A36 · Spencer, IAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were the pilot’s failure to use the Before Landing checklist due to being distracted while communicating with other aircraft and controlling the airplane in the…