NTSB investigations, NJ
16 cases where the defining event was Hard landing.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 2 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 3 |
| 2019 | 2 |
| 2021 | 1 |
| 2025 | 1 |
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\" = 'NJ' 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" = 'NJ' 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 ERA25LA349Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Lsa S R L Virus 912 LSA · Lincoln Park, NJThe pilot’s inadequate compensation for variable wind conditions, which resulted in a hard landing and loss of directional control.NTSB ERA21LA337Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV7 · Mount Holly, NJThe pilot’s improper recovery from a bounced landing, resulting in a touchdown on the nose gear first, resulting in damage to the nose gear and a runway excursion.NTSB GAA19CA399Accident · Serious injuriesData collectionFinal reportSchweizer SGS233 · Blairstown, NJThe student pilot's improper landing flare and the flight instructor's delayed remedial action, which resulted in a hard landing and the instructor sustaining a serious injury.NTSB DCA19CA167Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 757 · Newark, NJan improper landing flare, which resulted in a bounced landing and substantial damage.NTSB GAA17CA553Accident · No injuriesData collectionFinal reportAerotrike Safari · Bridgeton, NJThe pilot’s improper landing flare, which resulted in a hard landing while conducting an off-airport precautionary landing after a bird strike.NTSB ERA17FA317Accident · 2 fatalField investigationFinal reportSchweizer 269C · Medford, NJThe pilot's early entry into and failure to maintain rotor rpm during a forced landing autorotation after performing an engine shutdown in flight, which resulted in an uncontrolled descent. Contributing to the accident was the failure of maintenance personnel…NTSB GAA17CA253Accident · No injuriesData collectionFinal reportCirrus SR20 · Lakewood, NJThe student pilot’s failure to adequately compensate for crosswind conditions during a go-around and the flight instructor’s delayed remedial action.NTSB GAA15CA035Accident · No injuriesData collectionFinal reportCessna 152 · Farmingdale, NJThe pilot's improper flare which resulted in a loss of control and subsequent hard landing.NTSB ERA14CA250Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Sussex, NJThe pilot's failure to maintain proper airspeed while on approach, and his subsequent failure to recover from a bounced landing, which resulted in a hard landing.NTSB ERA14CA081Accident · No injuriesData collectionFinal reportCessna 172N · Farmingdale, NJThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA14CA016Accident · No injuriesData collectionFinal reportDenisar Richard A Lancair 320 · Lumberton, NJA hard landing by the pilot, which resulted in overload failure of landing gear components and surrounding structure.NTSB ERA13CA436Accident · No injuriesData collectionFinal reportBeech A23 24 · Lumberton, NJThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12CA004Accident · No injuriesData collectionFinal reportCessna 182P · Lincoln Park, NJThe pilot's improper landing flare.NTSB ERA11CA193Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Pittstown, NJThe student pilot's inadequate flare and the certified flight instructor's inadequate remedial action, which resulted in a hard landing.NTSB ERA09LA427Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mount Holly, NJA hard landing on an unknown date, resulting in damage to the left main landing gear support fitting.NTSB ERA09CA070Accident · No injuriesData collectionFinal reportCessna 172RG · Manville, NJThe pilot's improper flare, which resulted in a nose-wheel-first landing.