NTSB investigations
1,515 cases where the sequence of events included Abnormal runway contact.
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\" = '090' 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" = '090' 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 WPR12CA330Accident · No injuriesData collectionFinal reportAlon A2 · Compton, CAThe pilot's failure to maintain directional control during landing.NTSB CEN12LA676Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Elyria, OHThe pilot’s misjudged landing flare, which resulted in a hard landing.NTSB CEN12CA468Accident · No injuriesData collectionFinal reportPiper PA-11 · Neilsville, WIThe pilot did not maintain control of the airplane during an attempted aborted landing, which resulted in an inadvertent stall.NTSB CEN12CA461Accident · No injuriesData collectionFinal reportMooney M20K · Hutchinson, MNThe student pilot’s inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with obstructions.NTSB WPR12CA310Accident · No injuriesData collectionFinal reportPiper PA-46 · Delano, CAThe pilot's failure to extend the landing gear before touchdown. Contributing to the accident was the pilot's failure to perform the appropriate checklist due to distractions posed by another airplane inbound to the same airport and a cluttered radio…NTSB CEN12LA441Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Elkader, IAThe pilot's failure to attain the proper touchdown point while landing on the wet grass runway.NTSB ERA12CA461Accident · No injuriesData collectionFinal reportCzech Sport Piper Sport · Sanford, METhe student pilot’s inadequate landing flare and improper recovery from a bounced landing.NTSB WPR12CA311Accident · No injuriesData collectionFinal reportCessna T210L · Idaho Falls, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was an uncorrected malfunction of the landing gear warning horn system.NTSB ANC12FA073Accident · 1 fatalField investigationFinal reportCessna U206G · Homer, AKThe pilot’s improper evaluation of the weather conditions and his subsequent downwind water landing in gusting wind conditions, which resulted in a nose-over.NTSB WPR12CA300Accident · No injuriesData collectionFinal reportCessna T182T · Flagstaff, AZThe pilot’s inadequate landing flare after encountering a downdraft, which resulted in a hard landing.NTSB CEN12LA408Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Griswold, IAThe pilot’s failure to maintain adequate airspeed during an attempted go-around, resulting in an aerodynamic stall.NTSB ERA12CA414Accident · No injuriesData collectionFinal reportCessna 177 · West Milford, NJThe pilot's improper full flap retraction while performing a go-around maneuver, which resulted in a loss of airplane control.NTSB CEN12CA391Accident · No injuriesData collectionFinal reportLuscombe 8A · Mexico, MOThe airplane's encounter with a downdraft during the landing flare, which resulted in a hard landing.NTSB CEN12LA386Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Walnut Ridge, ARThe pilot's failure to maintain aircraft control after encountering a whirlwind or dust-devil during the landing flare.NTSB ANC12CA081Accident · No injuriesData collectionFinal reportPiper J3F-65 · Beluga, AKThe pilot's delayed decision to go around, which resulted in a hard landing.NTSB WPR12CA268Accident · Minor injuriesData collectionFinal reportCessna 182P · Woodland, CAThe pilot's failure to maintain a proper descent path during the approach to land, which resulted in a hard, bounced landing, and his improper retraction of the flaps during the subsequent attempted go-around.NTSB ERA12CA404Accident · No injuriesData collectionFinal reportCessna 172K · Tupelo, MSThe pilot's improper recovery from a bounced landing.NTSB CEN12LA345Accident · No injuriesLimited investigationFinal reportLearjet 60 · Aspen, COThe first officer’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during the final approach in known low-level windshear conditions, which resulted in an aerodynamic stall. Contributing to the accident…NTSB ANC12CA049Accident · No injuriesData collectionFinal reportCessna U206G · Homer, AKThe pilot's selection of unsuitable terrain for landing.NTSB CEN12LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Put-in-Bay, OHThe pilot's failure to attain a proper touchdown point at the proper speed, his failure to initiate a go-around, and the airplane’s inadequate climb gradient after the aborted landing, which resulted in impact with the trees.NTSB CEN12LA333Accident · Serious injuriesLimited investigationFinal reportWalters RV-8 · Hutchinson, MNThe pilot's failure to maintain proper airspeed during the landing attempt, his failure to maintain directional control, and his delayed attempted aborted landing at an airspeed that was too low, which resulted in an aerodynamic stall.NTSB WPR12CA240Accident · No injuriesData collectionFinal reportCessna P337H · Jerome, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use the checklist before landing.NTSB ERA12CA378Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-55-1 · Mocksville, NCThe glider pilot's failure to attain and maintain directional control during takeoff.NTSB ERA12CA359Accident · No injuriesData collectionFinal reportBeech V35B · Norwich, NYThe pilot’s failure to maintain airplane control while landing in a crosswind.NTSB ANC12CA040Accident · No injuriesData collectionFinal reportCessna T210L · Whittier, AKThe pilot’s failure use the prelanding checklist and to extend the landing gear before landing.NTSB ERA12LA335Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · South Canaan, PAThe pilot's delayed decision to abort the takeoff during shifting wind conditions.NTSB WPR12LA252Accident · No injuriesLimited investigationFinal reportStaudacher Hydroplanes S300X · Ephrata, WAThe pilot’s inadequate landing flare, which resulted in a bounced landing and subsequent loss of directional control.NTSB ERA12FA319Accident · 1 fatalField investigationFinal reportCessna 177B · Honesdale, PAThe pilot pitching the airplane to an excessive nose-up attitude during an aborted landing, which resulted in increased induced drag, diminished airspeed, and an aerodynamic stall/spin. Contributing to the accident was the pilot’s use of a sedating…NTSB ERA12CA320Accident · Minor injuriesData collectionFinal reportCessna 172F · Cambridge, NYThe pilot’s loss of airplane control during a takeoff in variable crosswind conditions.NTSB ANC12CA036Accident · No injuriesData collectionFinal reportShort Bros. & Harland SC7 Series 3 · Chefornak, AKThe pilot's misidentification of a nearby snow-covered road as the snow-covered runway in flat light conditions.NTSB CEN12CA263Accident · No injuriesData collectionFinal reportCampbell David Legacy · Durango, COThe pilot’s improper flare and subsequent aerodynamic stall, which resulted in a hard landing.NTSB WPR12LA444Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot's inadequate flare and compensation for gusting wind conditions, which resulted in a bounced landing.NTSB ANC12CA033Accident · No injuriesData collectionFinal reportAerospatiale AS350 B2 Ecureuil · Valdez, AKThe pilot's selection of an unsuitable landing surface, which resulted in the tail rotor contacting terrain.NTSB WPR12CA168Accident · Minor injuriesData collectionFinal reportApollo Monsoon · Oro Valley, AZThe pilot’s failure to lower the nose landing gear in time to prevent it from slamming onto the runway and collapsing.NTSB ERA12CA284Accident · No injuriesData collectionFinal reportTiger AG-5B · Lincoln Park, NJThe pilot's failure to maintain directional control during a go-around in a crosswind.NTSB CEN12CA240Accident · No injuriesData collectionFinal reportCessna 172S · Monroe, LAThe student pilot's improper landing flare, which resulted in a bounced landing and loss of directional control.NTSB ERA12CA266Accident · No injuriesData collectionFinal reportPiper PA-60-602P · Philadelphia, PAThe pilot's failure to maintain directional control while landing in gusting crosswind conditions.NTSB ERA12CA254Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2007 · Groveland, FLThe pilot's failure to maintain directional control during a go-around maneuver in gusty crosswind conditions.NTSB CEN12CA205Accident · Minor injuriesData collectionFinal reportFurru Donald Jeffrey Skyranger V MAX · Viola, ARThe pilot did not maintain adequate airspeed during a go-around, which resulted in an aerodynamic stall.NTSB CEN12CA213Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluffs, IAThe student pilot’s improper flare and inadequate recovery from a bounced landing, which resulted in a loss of directional control.NTSB ERA12CA244Accident · No injuriesData collectionFinal reportMooney M20M · Clearwater, FLThe pilot’s failure to extend the landing gear before landing due to his distraction regarding another airplane in the traffic pattern.NTSB ERA12FA225Accident · 5 fatalField investigationFinal reportCessna 501 · Franklin, NCThe pilot's failure to achieve a stabilized approach, resulting in a nose-first, bounced landing. Contributing to the accident was the pilot's activation of only one thrust reverser, resulting in asymmetrical thrust.NTSB WPR12CA134Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Dillingham, HIThe student pilot’s inadequate recovery from a bounced landing.NTSB DCA12WA040Incident · No injuriesForeign investigationDornier 328 · Reykjavik, IcelandThe Iceland Air Accident Investigation Board (AAI) has notified the NTSB of an incident involving a Dornier D328 that occurred on February 20, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…NTSB WPR12LA104Accident · No injuriesLimited investigationFinal reportBeech G18 · Hollister, CAThe pilot’s failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall and a subsequent hard landing, loss of directional control, and ground loop.NTSB CEN12CA157Accident · Minor injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot did not extend the landing gear before landing.NTSB WPR12CA088Accident · No injuriesData collectionFinal reportCessna 172S · Mokuleia, HIThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB WPR12CA079Accident · No injuriesData collectionFinal reportCessna 172M · Richland, WAThe student pilot's improper landing flare and inadequate directional control during landing.NTSB CEN12LA126Accident · No injuriesLimited investigationFinal reportAviat A1 · Somerset, COThe pilot's inadequate takeoff planning/preparation, which resulted in the airplane impacting a snow drift during the takeoff roll.NTSB CEN12CA121Accident · No injuriesData collectionFinal reportButler John R SX 300 · Truth or Consequences, NMThe pilot did not maintain airplane control during takeoff due to his distraction with the improperly secured canopy, which he forgot to latch.