NTSB investigations
3,632 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 CEN26LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Bay City, MIThe pilot's failure to ensure the landing gear was down and locked before landing.NTSB CEN26LA092Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · San Marcos, TXThe flight instructor’s failure to properly configure the elevator trim for the takeoff, that resulted in a hard landing. Contributing to the accident was the flight instructor’s failure to follow the before takeoff checklist.NTSB CEN26LA078Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Sealy, TXThe failure of the nose wheel during landing that resulted in a loss of directional control and impact with terrain.NTSB WPR26LA075Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-235C · Jay Em, WYThe loss of directional control and subsequent nose over due to the inadvertent engagement of the right wheel parking brake as a result of cabin floor carpeting migrating between the right brake master cylinder and parking brake locking lever.NTSB ERA26LA083Accident · No injuriesClass 4 · LimitedFinal reportIcon A5 · Gulf Shores, ALA nose landing gear collapse during landing.NTSB CEN26LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Taylor, TXThe pilot’s inadequate preflight inspection that resulted in a loss of engine power due to water contamination.NTSB ERA26LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · East Farmingdale, NYA loss of brake effectiveness during taxi, which resulted in a collision with another airplane.NTSB WPR26LA057Accident · No injuriesClass 4 · LimitedFinal reportPorto Risen SV · Carson City, NVThe pilot's failure to extend the landing gear prior to landing.NTSB ERA26LA086Accident · No injuriesClass 4 · LimitedFinal reportPipistrel D O O Panthera X152 · Atlanta, GAThe pilot’s failure to extend the landing gear before landing.NTSB ERA26LA058Accident · No injuriesClass 4 · LimitedFinal reportHuebbe Tom MAX TH · Inverness Highlands South, FLThe pilot’s failure to maintain directional control on takeoff. Contributing to the accident was the aircraft design that did not incorporate differential braking.NTSB ERA26LA057Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Eastman, GAThe flight instructors failure to extend the landing gear before landing.NTSB ENG26LA011Incident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2C11 · Hibbing, MNThe elevator control restriction was caused by the failure of an elevator autopilot servo control cable which failed due to cyclic fatigue. The slack in the cable wrapped around the servo mount in such a way that it interfered with the rotation of the servo…NTSB ERA26LA045Accident · No injuriesClass 4 · LimitedFinal reportBeech 95 · Edgewater, FLThe pilot’s failure to extend the landing gear prior to landing.NTSB ERA26LA043Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 · Dothan, ALThe failure of the left main landing gear actuator rods, which resulted in a gear up landing.NTSB ERA26LA071Accident · No injuriesClass 4 · LimitedFinal reportBeech D95A · Jasper, ALThe pilots’ failure to ensure that the airplane’s landing gear was extended before landing. Contributing was the flight instructor’s inadequate supervision during the landing approach.NTSB CEN26LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Brainerd, MNThe pilot’s failure to extended to landing gear before landing.NTSB CEN26LA041Accident · No injuriesClass 4 · LimitedFinal reportDouglas B-26B · Ponca City, OKFailure of the nose landing gear link which resulted in a loss of directional.NTSB ERA26LA028Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Vultee 28-5ACF · Dayton, TNThe collapse of the left main landing gear due to the fatigue fracture of the lower landing gear actuator bolt.NTSB CEN26LA033Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182H · Lakeview, ARThe pilot’s failure to maintain a proper approach path during landing which resulted in a collision with terrain short of the runway. Contributing to the accident was the improper flap position during landing, and the pilot being fatigued.NTSB ERA26LA030Accident · No injuriesClass 4 · LimitedFinal reportHugh Nunnally Farrior Cozy MK IV · McRae-Helena, GAThe pilot’s failure to extend the nose landing gear, which resulted in a nose gear up landing. Contributing to the accident was the pilot’s inappropriate decision to continue to fly with known delamination damage to the propeller.NTSB ERA26LA023Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · St. Augustine, FLThe student pilot’s failure to properly set the elevator trim prior to takeoff, which resulted in her inability to effectively control the airplane’s pitch and a collision with trees at the end of the runway during initial climb.NTSB CEN26LA028Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Hondo, TXThe pilot’s failure to extend the landing gear before landing due to distraction and his failure to conduct the Before Landing checklist.NTSB CEN26LA025Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Eau Claire, WIThe pilot’s failure to ensure that the landing gear was properly extended before landing. Contributing to the accident was the pilot’s unfamiliarity with the landing gear warning horn and failure to verify the gear was extended with the cockpit position…NTSB WPR26LA029Accident · No injuriesClass 4 · LimitedFinal reportRoderick James Willmore Kitfox S7 Supersport · Kilgore, IDThe pilot's failure to maintain directional control during the takeoff. Contributing to the accident was the separation of the control stick grip.NTSB WPR26LA028Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Phoenix, AZA worn tailwheel steering mechanism, which resulted in a locked tailwheel and a ground loop during a landing roll.NTSB CEN26LA021Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Tulsa, OKThe pilot’s improper landing flare which resulted in a hard bounced landing.NTSB ERA26LA020Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Canon, GAThe pilot’s inadvertent application of brakes during the landing roll, which resulted in a noseover.NTSB WPR26LA018Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Imnaha, ORThe pilot’s continued application of brakes during an aborted takeoff in a tailwind on down-sloping terrain, which resulted in a nose-over.NTSB ERA26LA009Accident · No injuriesClass 4 · LimitedFinal reportCessna 182H · Smithfield, RIMaintenance personnel’s improper rigging of the elevator trim system, which resulted in a hard landing. Contributing was the maintenance personnel and pilot’s failure to perform adequate post maintenance/preflight inspections.NTSB ERA26LA002Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260 · Parkland, FLThe pilot’s failure to retract the amphibious airplane’s landing gear before conducting a forced landing on the water, which resulted in a nose over.NTSB CEN26LA002Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 7GC · Haskell, OKThe pilot’s excessive braking during the landing roll, which resulted in a nose over. Contributing to the accident was the pilot’s lack of experience with the recently installed brakes and tundra tires.NTSB ANC25LA117Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31 · Kotlik, AKThe pilot’s failure to extend the landing gear before landing.NTSB ERA25LA371Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American T-6G · Rossville, TNThe pilot’s failure to adequately monitor the airplane’s path during takeoff toward the setting sun. Contributing was the undetected worn and fractured tailwheel locking pin.NTSB CEN25LA399Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV9 · Stephenville, TXThe pilot’s failure to ensure the canopy and the cockpit were properly secured during the hand prop sequence.NTSB CEN25LA398Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-60-601P · Del Norte, COThe loss of directional control during landing roll due to a flat tire.NTSB CEN25LA402Accident · No injuriesClass 4 · LimitedFinal reportTextron 525C · Baton Rouge, LAThe improper installation of the trunnion pin, which resulted in a failure of the right main landing gear. Contributing to the accident was the failure of maintenance personnel to follow the aircraft manufacturer’s maintenance procedures.NTSB CEN25LA394Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Henderson, TXThe pilot’s failure to extend the main landing gear prior to landing, which resulted in a gear up landing. Contributing to the accident was the pilot’s distraction during the approach.NTSB CEN25LA393Accident · No injuriesClass 4 · LimitedFinal reportFloyd G Halderman JR RV-6 · Cambridge, MNThe pilot’s continued operation of the faulty fuel selector valve which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the degraded operation of the fuel selector valve and the pilot’s poor decision to operate the…NTSB WPR25LA293Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Lake Havasu City, AZThe pilot’s failure to extend the landing gear before landing due to distraction and failure to conduct the before landing checklist.NTSB CEN25LA392Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA20-C1 · Terre Haute, INThe failure of the nose landing gear strut and associated nosewheel separation during takeoff.NTSB WPR25LA283Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150F · Rigby, IDThe flight instructor’s improper flap position during takeoff, which resulted in degraded climb performance and a subsequent impact with a building.NTSB ERA25LA351Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Smyrna, TNThe pilot’s failure to extend the landing gear before landing.NTSB ERA25LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna P210 · Akron, OHThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the fight instructor’s inadequate supervision of the pilot.NTSB CEN25LA401Accident · No injuriesClass 3 · LimitedFinal reportCubCrafters CCK-2000 · Thompsonville, MIA total loss of engine power due to a lack of ignition resulting from a fractured alternator ring terminal and the builder’s incorrect installation of the wire connecting to the alternator. Contributing to the total loss of engine power was the failure of the…NTSB ERA25LA335Accident · No injuriesClass 4 · LimitedFinal reportLafferty Jack SEA REY · Bell, FLThe pilot’s failure to raise the landing gear before landing on the water.NTSB CEN25LA371Accident · No injuriesClass 4 · LimitedFinal reportCessna 560 · Dallas, TXThe pilot's failure to extend the landing gear before landing.NTSB CEN25LA361Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Caro, MIThe pilot’s failure to remove the tow bar before flight.NTSB WPR25LA300Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Firebaugh, CAA loss of directional control during landing due to the partial separation of the right main landing gear oleo strut from a failed weld.NTSB CEN25LA356Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S-76 · Round Mountain, TXThe flight crew’s failure to properly identify the heliport in dark night conditions, which resulted in the flight crew attempting to land and a subsequent impact with trees and terrain.NTSB DCA25LA308Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Canada BD500 · Denver, COUnidentified burned debris in an aft galley oven, which generated smoke and odor in the cabin and led to an air turnback and subsequent evacuation, during which a serious injury occurred.