NTSB investigations
3,664 cases where the sequence of events included Runway excursion.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA10LA434Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLA loss of engine power for undetermined reasons.NTSB WPR10LA413Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Buckeye, AZAn increase in engine rpm and vibration, which resulted in an aborted takeoff and runway excursion. The reason for the increased engine rpm and vibration could not be determined because of postaccident fire damage.NTSB ERA10CA441Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oakland, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN10CA481Accident · Serious injuriesData collectionFinal reportOliver A Bruce RV6-A · Trenton, MOThe canopy opening shortly after takeoff due to an inadequate repair and subsequent failure of the canopy latch, resulting in a emergency landing. Contributing to the accident was the lack of available runway remaining for the forced landing.NTSB WPR10CA405Accident · No injuriesData collectionFinal reportCessna T182T · McCall, IDThe pilot's delay in making the decision to abort the takeoff. Contributing to the accident was the condition of the takeoff surface, and the high density altitude.NTSB WPR10CA404Accident · Minor injuriesData collectionFinal reportCarr Bryan Vans RV-6A · Grass Valley, CAThe pilot’s failure to attain a proper touchdown point that resulted in an overrun of the runway and nose over.NTSB WPR10CA372Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Garberville, CAThe pilot’s improper airspeed, misjudged approach, and failure to attain the proper touchdown point. Contributing to the accident was the pilot’s lack of familiarity with the airport.NTSB ERA10CA418Accident · No injuriesData collectionFinal reportCessna 182F · Canon, GAThe pilot’s improper recovery from a bounced landing.NTSB CEN10LA474Accident · No injuriesLimited investigationFinal reportCessna A185F · Farmington, NMPre-existing damage of the through-bolt that attached the inboard end of the gear leg to the airframe hard-point, likely caused during maintenance on the gear.NTSB ERA10CA413Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Lancaster, PAThe student pilot’s failure to maintain directional control of the airplane during takeoff.NTSB ERA10CA412Accident · No injuriesData collectionFinal reportMooney M20M · Poughkeepsie, NYThe pilot's improper flare which resulted in a hard landing, loss of directional control and runway excursion.NTSB WPR10CA391Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Bridgeport, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA10CA406Accident · Minor injuriesData collectionFinal reportCessna 172 · Chattanooga, TNThe student pilot's improper execution of the go-around procedure.NTSB ERA10LA405Accident · No injuriesLimited investigationFinal reportGlines Sportsman GS-2 · Morrisville, VTThe pilot's improper flare during a forced landing. Contributing to the accident was a loss of fuel pressure for undetermined reasons.NTSB CEN10CA464Accident · No injuriesData collectionFinal reportCessna 414 · Vici, OKThe pilot's failure to ensure adequate runway remaining during landing.NTSB CEN10LA457Accident · No injuriesLimited investigationFinal reportCessna 180B · Burnet, TXThe failure of the tailwheel compression spring, which resulted in a loss of directional control during landing.NTSB ERA10CA397Accident · No injuriesData collectionFinal reportLuscombe 8C · Zelienople, PAThe pilot's loss of directional control while taking off with a gusting wind.NTSB ERA10CA388Accident · Minor injuriesData collectionFinal reportCessna 177B · Middleberry, VTThe pilot’s delayed decision to abort the takeoff.NTSB WPR10CA378Accident · No injuriesData collectionFinal reportPorter James Grant Superior CUB · Caldwell, IDThe pilot’s failure to maintain directional control during landing.NTSB ERA10CA381Accident · No injuriesData collectionFinal reportCessna 172N · Stonington, METhe pilot's failure to maintain directional control during a crosswind landing.NTSB ERA10LA376Accident · No injuriesLimited investigationFinal reportBeech K35 · Philadelphia, MSA throttle control malfunction during landing for undetermined reasons, resulting in a runway overrun.NTSB WPR10LA365Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Prescott, WAThe airplane’s inability to maintain a positive rate of climb after takeoff for undetermined reasons. Contributing to the accident was the pilot’s delayed reaction to initiate an emergency release of the spray mixture.NTSB CEN10LA420Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Toulin, ILA partial loss of engine power as a result of a cracked cylinder and the reduced visibility due to the oil-covered windshield.NTSB ERA11CA163Accident · No injuriesData collectionFinal reportAeronca 11AC · Randolph, NYThe certified flight instructor's delayed response to the student pilot's loss of directional control during takeoff, which resulted in a runway excursion and collision with a building.NTSB ERA10CA369Accident · No injuriesData collectionFinal reportCessna 152 · Indian Head, MDThe pilot's loss of control while landing in gusting crosswind conditions.NTSB WPR10CA358Accident · No injuriesData collectionFinal reportAviat A-1B · Casper, WYThe pilot's failure to maintain directional control during landing.NTSB WPR10CA355Accident · No injuriesData collectionFinal reportLeonard Trudy Kitfox III · Monument Valley, UTThe pilot's inadequate compensation for the wind effects and failure to maintain directional control during an attempted go-around from a landing.NTSB ERA10LA375Accident · No injuriesLimited investigationFinal reportCessna 182 · Crisfield, MDThe pilot's delayed decision to abort the takeoff, which resulted in a runway excursion.NTSB ERA10CA368Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · St. Petersburg, FLThe pilot's loss of directional control while taking off with a crosswind.NTSB ANC10CA091Accident · No injuriesData collectionFinal reportAvions Max Holste MH 1521 Broussard · Skwentna, AKThe pilot's inadequate crosswind compensation, which resulted in a loss of directional control.NTSB WPR10LA349Accident · No injuriesLimited investigationFinal reportCessna 310K · El Monte, CAThe pilot’s failure to maintain directional control during the takeoff ground roll.NTSB ERA10CA358Accident · No injuriesData collectionFinal reportCessna 172 · Fairhope, ALThe student pilot's failure to maintain directional control during a crosswind takeoff.NTSB WPR10CA346Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Yellow Pine, IDThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the wet condition of the grass runway.NTSB ERA10FA356Accident · 1 fatalField investigationFinal reportCirrus SR20 · Chapel Hill, NCThe pilot's improper recovery from a bounced landing and subsequent improper go-around procedure, which resulted in a loss of directional control, runway excursion, and collision with a tree.NTSB CEN10IA397Incident · No injuriesIncident investigationFinal reportBell 206 · Gulf of Mexico, LAImproper reassembly of the collective flight controls by maintenance personnel. Contributing to the incident were inadequate postmaintenance examinations by maintenance personnel and inadequate preflight inspections by two pilots.NTSB ERA10CA360Accident · No injuriesData collectionFinal reportPiper PA28R · Sarasota, FLThe pilot's loss of directional control during the takeoff roll.NTSB CEN10CA407Accident · No injuriesData collectionFinal reportAeronca 7AC · Santa Fe, NMThe pilot's failure to maintain directional control of the airplane while landing with gusting winds.NTSB CEN10LA389Accident · No injuriesLimited investigationFinal reportCessna 210 · Houston, TXThe failure of a hydraulic fluid line, which caused a loss of hydraulic pressure to the landing gear extension system and resulted in the partial collapse of the right main landing gear during touchdown.NTSB CEN10CA375Accident · No injuriesData collectionFinal reportPiper PA32 · Albuquerque, NMThe pilot's failure to maintain directional control of the airplane during takeoff.NTSB WPR10TA335Accident · No injuriesFinal reportPiper PA-18-150 · Dillon, MTThe pilot's failure to maintain directional control during landing.NTSB CEN10CA377Accident · No injuriesData collectionFinal reportAero Commander 100 · Jacksonville, ARThe pilot's failure to maintain an appropriate approach speed and his delayed decision not to initiate a go-around. Contributing to the accident was the pilot's lack of experience in the airplane type.NTSB CEN10CA366Accident · No injuriesData collectionFinal reportAviat A-1B · Centennial, COThe student pilot's failure to maintain directional control and the certified flight instructor's delay in remedial action.NTSB WPR10CA322Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · Sequim, WAThe pilot’s failure to maintain directional control during landing due to an encounter with sun glare.NTSB ERA10CA341Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Farmingdale, NYThe student pilot's failure to maintain directional control during a crosswind landing.NTSB ERA10CA339Accident · No injuriesData collectionFinal reportPiper J3C-65 · Thomaston, GAThe pilot’s failure to maintain directional control during landing.NTSB WPR10CA329Accident · No injuriesData collectionFinal reportCornett Steven M Glastar · Smiley Creek, IDThe pilot's decision to not use all available runway length and his delay in aborting the takeoff, which resulted in the airplane sliding off the end of the grass strip and colliding with a ditch.NTSB ERA10CA334Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Gordonsville, VAThe student pilot’s failure to maintain directional control, and his excessive braking during the landing rollout.NTSB CEN10CA436Accident · Minor injuriesData collectionFinal reportCessna 310C · Ashdown, ARThe pilot’s loss of directional control during the takeoff roll and his lack of experience in the airplane.NTSB WPR10LA312Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Parker, AZThe pilot's failure to maintain directional control while landing with a crosswind.NTSB WPR10CA304Accident · No injuriesData collectionFinal reportCessna A185F · Bryce Canyon, UTThe pilot's inadequate compensation for the crosswinds during takeoff.