NTSB investigations, IN
24 cases where the defining event was Hard landing.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 2 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 4 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'IN' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092')
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."eventStateOrRegion" = 'IN' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '092') 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 CEN22LA369Accident · No injuriesClass 4 · LimitedFinal reportICP Savannah S · Evansville, INThe pilot’s improper landing flare in gusting winds, which resulted in a hard landing and the nose gear collapsing.NTSB CEN22LA292Accident · No injuriesClass 4 · LimitedFinal reportMagnaghi Aeronautica SKY Arrow LSA · West Lafayette, INThe pilot’s failure to maintain proper airspeed while landing in gusting winds, which resulted in a hard landing and a runway excursion.NTSB CEN22LA210Accident · No injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Angola, INThe pilot’s failure to maintain control of the airplane while landing in gusting wind conditions, which resulted in a hard landing and the nose landing gear collapse.NTSB CEN22LA184Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-260 · Terre Haute, INA hard landing, which resulted in the failure of the right main landing gear outer bearing and collapse of the landing gear.NTSB CEN21LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Indianapolis, INThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB GAA19CA571Accident · No injuriesData collectionFinal reportCessna 152 · Lafayette, INThe student pilot's improper landing flare, which resulted in a bounced landing and subsequent nose landing gear collapse.NTSB GAA19CA329Accident · No injuriesData collectionFinal reportErcoupe 415 · Lafayette, INThe flight instructor's failure to maintain pitch control and his improper landing flare, which resulted in a hard landing.NTSB GAA18CA195Accident · No injuriesData collectionFinal reportPiper PA24 · Knox, INThe flight instructor’s improper landing flare, which resulted in a hard landing.NTSB GAA16CA491Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Valparaiso, INThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA16CA226Accident · No injuriesData collectionFinal reportCessna TR182 · Bloomington, INThe pilot's failure to maintain the airplane's descent rate resulting in a hard landing, and subsequent substantial damage to the firewall.NTSB CEN16LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · Gary, INThe pilot's failure to maintain the glidepath and appropriate airspeed during landing in icing conditions, which resulted in an aerodynamic stall and a hard landing.NTSB GAA15CA208Accident · No injuriesData collectionFinal reportCessna 172R · North Vernon, INThe pilot's failure to maintain pitch control during the landing touchdown, resulting in a hard landing.NTSB CEN15CA373Accident · No injuriesData collectionFinal reportErcoupe 415-C · Alexandria, INThe pilot's failure to maintain/attain adequate airspeed and attitude during landing that resulted in a hard landing. Contributing was the pilot's diverted attention to air traffic and the reduction of perceptible audio cues due to noise attenuating headsets.NTSB CEN15LA103Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons USA 120A · Peru, INThe hard landing due to a higher-than-forecast surface wind, which resulted in a serious neck injury to the pilot.NTSB CEN14LA374Accident · No injuriesLimited investigationFinal reportCessna 172N · Rockville, INA partial loss of engine power due to a failure of the dual magneto system. Contributing to the accident was the improper maintenance of the duel magneto system.NTSB CEN14CA207Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Bloomington, INThe pilot did not maintain control of the airplane while landing.NTSB CEN13CA120Accident · No injuriesData collectionFinal reportRobidoux Lionel Wittman W 10 · Hobart, INThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and subsequent hard landing.NTSB CEN12LA053Accident · Minor injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Noblesville, INThe hard landing the pilot performed with a quartering tailwind, leading to the helicopter's rollover. Contributing to the accident was the pilot’s reliance on a weather service that did not provide a primary weather product.NTSB CEN10CA289Accident · No injuriesData collectionFinal reportCessna 172S · Greenfield, INThe pilot's improper landing flare and recovery from a bounced landing.NTSB CEN09CA217Accident · No injuriesData collectionFinal reportCessna 172R · Lafayette, INThe pilot's improper flare. Contributing to the accident were the wind gusts.NTSB CEN09CA200Accident · No injuriesData collectionFinal reportCessna 152 · Fort Wayne, INThe student pilot's improper flare and recovery from a bounced landing.NTSB CEN09CA208Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Valparaiso, INThe pilot's improper flare during landing, resulting in a bounced landing.NTSB CEN09LA088Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Gary, INThe pilot's excessive airspeed and improper flare while landing in gusting winds.NTSB CHI08CA072Accident · No injuriesData collectionFinal reportAvid MK-IV · Boswell, INThe pilot's inadequate compensation for the crosswind condition which resulted in a loss of directional control during a bounced landing. Factors associated with the accident were the improper flare, the crosswind, and the trees which the airplane contacted.