NTSB investigations
899 cases where NTSB found Runway/land/takeoff/taxi surface.
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\", '030230')) 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", '030230')) 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 GAA17CA446Accident · No injuriesData collectionFinal reportPiper PA46 · Franklin, VAA collision with a deer during the landing roll, which resulted in a runway excursion.NTSB GAA17CA474Accident · No injuriesData collectionFinal reportCessna 210 · Bettles, AKThe pilot's failure to maintain an appropriate glidepath during the approach to the runway over glassy water and in glaring sun conditions.NTSB ERA17LA225Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 15 · Farmville, VAThe pilot’s improper decision to depart from an unsuitable off-airport surface which resulted in his subsequent exceedance of the airplane's critical angle of attack, an aerodynamic stall and loss of control.NTSB GAA17CA387Accident · No injuriesData collectionFinal reportPiper PA 12 · Chickaloon, AKThe pilot’s improper landing flare on a turf runway, which necessitated a go-around during which he failed to establish a climb.NTSB GAA17CA347Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Watervliet, MIThe flight instructor's inadequate preflight planning, which resulted in a takeoff over maximum gross weight from a turf runway in high density altitude conditions and the airplane’s inability to attain a climb rate and subsequent collision with trees.NTSB GAA17CA353Accident · No injuriesData collectionFinal reportCessna 207 · Homer, AKThe pilot's decision to land on unsuitable terrain, which resulted in the nosewheel breaking and a subsequent noseover.NTSB GAA17CA316Accident · No injuriesData collectionFinal reportMalinowski Walter S RV8 · Canaan Valley, WVThe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB GAA17CA294Accident · No injuriesData collectionFinal reportDehavilland DHC 2 · Petersville, AKThe pilot’s selection of unsuitable terrain for taxiing, which resulted in a nose-over.NTSB GAA17CA332Accident · No injuriesData collectionFinal reportCessna 208 · Elfin Cove, AKThe pilot’s failure to recognize the magnitude of the swell size during landing, which resulted in a tail-low hard water landing.NTSB GAA17CA291Accident · No injuriesData collectionFinal reportCessna T182 · Carson City, NVThe pilot’s unstabilized approach during the landing flare and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA17CA278Accident · Minor injuriesData collectionFinal reportReims Cessna FR172 · De Pere, WIThe pilot’s failure to maintain directional control during takeoff with a tailwind.NTSB GAA17CA267Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164 · Walnut Ridge, ARThe pilot’s failure to maintain directional control during the go-around with a tailwind.NTSB GAA17CA239Accident · No injuriesData collectionFinal reportBeech C23 · Fallon, NVThe pilot's inaccurate takeoff performance calculations and failure to maintain directional control during an aborted takeoff.NTSB GAA17CA238Accident · No injuriesData collectionFinal reportCheung David S Vans RV6 · Indianola, IAThe pilot’s failure to maintain an adequate approach path, which resulted in a long landing and subsequent runway overrun.NTSB ERA17CA157Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Kingsland, GAThe pilot's improper landing flare, which resulted in a hard landing and subsequent nose-over.NTSB GAA17CA230Accident · No injuriesData collectionFinal reportCessna 180 · Manchester, CAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the total loss of engine power.NTSB ERA17CA152Accident · Minor injuriesData collectionFinal reportLazear John T Zenair Stol CH 701 · Windsor Twp, PAThe pilot's improper pretakeoff planning, his failure to maintain adequate airspeed, and his exceedance of the airplane's critical angle of attack during a short-field takeoff with a tailwind, which resulted in an aerodynamic stall.NTSB GAA17CA210Accident · No injuriesData collectionFinal reportPiper PA22 · Soldotna, AKThe pilot’s unstabilized approach and failure to attain the proper touchdown point, which resulted in a runway overrun and collision with a snowbank.NTSB GAA17CA204Accident · Minor injuriesData collectionFinal reportCessna 170 · Death Valley, CAThe pilot’s improper compensation for crosswind conditions during the landing flare and his subsequent failure to maintain directional control during the landing.NTSB GAA17CA188Accident · No injuriesData collectionFinal reportPiper PA 12 · Anchorage, AKThe pilot’s failure to maintain directional control during the taxi on skis on hard-packed snow in gusting wind conditions.NTSB GAA17CA190Accident · Minor injuriesData collectionFinal reportDavis Frank R Xenos Motorglider · Minden, NVThe pilot’s failure to maintain directional control in variable wind conditions.NTSB ERA17LA122Accident · No injuriesLimited investigationFinal reportXtremeair XA42 · West Palm Beach, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preimpact mechanical failures or malfunctions that would have precluded normal operation.NTSB GAA17CA156Accident · No injuriesData collectionFinal reportCessna 120 · Orange, MAThe pilot’s selection of unsuitable terrain for landing, which resulted in a nose-over.NTSB GAA17CA159Accident · No injuriesData collectionFinal reportPiper PA22 · Big Lake, AKThe contamination of snow and ice on the left main landing gear and brake, which prevented the wheel from rolling during touchdown and resulted in a nose-over.NTSB GAA17CA153Accident · No injuriesData collectionFinal reportStinson 108 · Valparaiso, INThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB GAA17CA142Accident · No injuriesData collectionFinal reportCessna T182 · Three Rivers, MIThe pilot’s failure to maintain sufficient airspeed during the landing flare, which resulted in a hard landing and a nose-over.NTSB GAA17CA187Accident · No injuriesData collectionFinal reportPiper PA22 · Ruby, AKThe pilot’s failure to maintain directional control while landing in flat light conditions on a hard-packed snow-covered landing area.NTSB GAA17CA151Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Holtville, CAThe pilot’s initiation of a left turn at a low altitude with low airspeed and a tailwind while operating near maximum gross weight, which resulted in the helicopter losing altitude, touching down on a dirt surface, and a subsequent dynamic rollover.NTSB GAA17CA134Accident · No injuriesData collectionFinal reportCessna 180 · Tyonek, AKThe pilot’s improper decision to land on a snow-covered airstrip with a tundra tire-equipped airplane, which resulted in a nose-over.NTSB WPR17LA062Accident · No injuriesLimited investigationFinal reportAviat A-1C-200 · Jiggs, NVAn engine anomaly for reasons that could not be determined, which resulted in a precautionary landing in deep snow and a subsequent noseover.NTSB CEN17LA123Accident · No injuriesLimited investigationFinal reportBeech C 99 · Durango, COThe pilot's inability to maintain directional control during takeoff in crosswind conditions on a contaminated runway, which resulted in a runway excursion.NTSB CEN17LA078Accident · Serious injuriesLimited investigationFinal reportTextron 525C · Howell, MIThe pilot's attempted landing on the ice-covered runway, which resulted in a runway excursion and impact with terrain. Contributing to the accident was airport personnel's lack of training regarding issuance of NOTAMsNTSB GAA17CA113Accident · No injuriesData collectionFinal reportAeronca 7AC · Compton, CAThe pilot’s failure to maintain runway alignment during landing in gusting crosswind conditions, which resulted in an off-runway landing in soft dirt and a nose-over.NTSB GAA17CA110Accident · No injuriesData collectionFinal reportChristen Industries A 1 · Milton-Freewater, ORThe pilot's decision to take off from unsuitable terrain with a tailwind, which resulted in a nose-over.NTSB GAA17CA106Accident · Minor injuriesData collectionFinal reportMaule M7 · Palouse, WAThe pilot’s failure to maintain directional control on an ice- and snow-covered runway during taxi with a crosswind, which resulted in a runway excursion.NTSB GAA17CA100Accident · No injuriesData collectionFinal reportCessna 150 · Warren, MNThe noncertificated pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion.NTSB ERA17LA071Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palm Bay, FLUnknown maintenance personnel’s improper routing of electrical wires in the engine compartment, which resulted in chafing and a subsequent in-flight fire.NTSB ERA17LA070Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Ormond Beach, FLThe pilot's impairment by alcohol before and during the flight, which led to his improper fuel management and resulted in fuel exhaustion and a subsequent loss of engine power.NTSB GAA17CA101Accident · No injuriesData collectionFinal reportMaule MX 7 · Willow, AKThe pilot’s failure to ensure that the runway was clear of any obstacles before departure, which resulted in the airplane impacting a snowdrift.NTSB CEN17LA048Accident · No injuriesLimited investigationFinal reportArion Lightning LS-1 · Goshen, INA partial loss of engine power due to carburetor icing and the subsequent forced landing on a rough/soft field.NTSB GAA17CA084Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Pensacola, FLThe student pilot’s incorrect brake application during the landing roll, which resulted in a loss of directional control.NTSB ERA17LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of torque on the No. 3 connecting rod’s nuts, which resulted in the failure of the No. 3 connecting rod’s bolts and a subsequent total loss of engine power due to the operator's maintenance personnel’s improper installation of the connecting rod nuts.NTSB GAA17CA076Accident · No injuriesData collectionFinal reportCessna 172 · Salmon, IDThe airplane's encounter with a depression in a dirt runway during takeoff, which resulted in a tail strike.NTSB CEN17LA036Accident · Minor injuriesLimited investigationFinal reportStinson L 5 · San Marcos, TXThe pilot’s improper fuel management before landing, which resulted in fuel starvation and the subsequent total loss of engine power during a subsequent go-around when the fuel became unported during the climbing turn.NTSB GAA17CA040Accident · No injuriesData collectionFinal reportPiper PA 20S · Arcadia, FLThe pilot's improper pitch and power control during landing in a straight float-equipped airplane on grass in crosswind conditions, which resulted in a loss of directional control.NTSB GAA17CA051Accident · No injuriesData collectionFinal reportCessna 152 · Chickaloon, AKThe flight instructor's delay in aborting the takeoff from a turf runway, which resulted in a runway overrun.NTSB GAA17CA027Accident · Minor injuriesData collectionFinal reportPiper PA18 · Palmer, AKThe airplane's encounter with a depression while the pilot applied excessive braking during the landing roll on a grass airstrip, which resulted in a nose-over.NTSB GAA17CA028Accident · Minor injuriesData collectionFinal reportNewkirk Thomas Ray Vans RV 6 · Garland, NCThe pilot's improper landing flare, which resulted in a bounced landing on the grass runway.NTSB GAA17CA020Accident · No injuriesData collectionFinal reportRemos Remos GX · Lowell, ARThe pilot’s decision to take off with a prevailing tailwind and insufficient distance to ensure obstacle clearance, which resulted in a collision with a tree.NTSB GAA17CA022Accident · No injuriesData collectionFinal reportAllen Robert RV6 · Ocala, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.