NTSB investigations, NJ
22 cases where the sequence of events included Abnormal runway contact.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 6 |
| 2017 | 2 |
| 2018 | 1 |
| 2021 | 2 |
| 2023 | 1 |
| 2024 | 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 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."eventStateOrRegion" = 'NJ' AND c."eventCountry" = 'USA' AND 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 ERA25LA045Accident · No injuriesClass 4 · LimitedFinal reportHawker Beechcraft G58 · Fairfield Township, NJThe pilot’s failure to properly configure the landing gear for landing.NTSB ERA24LA048Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Blairstown, NJThe student pilot’s improper control inputs and the flight instructor’s delayed remedial action, which resulted in a loss of control during an attempted go-around.NTSB ERA22LA070Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Old Bridge, NJThe student pilot’s loss of control during a go-around, which resulted in an aerodynamic stall.NTSB ERA22LA040Accident · No injuriesClass 4 · LimitedFinal reportJack A Frohbieter Questair Venture · Robbinsville, NJThe pilot’s failure to extend the landing gear prior to landing, which resulted in substantial damage to the lower fuselage. Contributing to the accident was the pilot’s failure to utilize the aircraft checklist.NTSB GAA18CA472Accident · Minor injuriesData collectionFinal reportCessna 140 · Mount Holly, NJThe pilot's improper landing flare, which resulted in the airplane ballooning upon landing, and his subsequent loss of directional control and excessive brake application.NTSB GAA18CA045Accident · No injuriesData collectionFinal reportCessna 172 · Trenton, NJThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA17CA162Accident · No injuriesData collectionFinal reportCessna T337 · Linden, NJThe pilot’s abrupt maneuver to avoid birds during short final approach, which resulted in a hard, bounced landing.NTSB GAA17CA080Accident · No injuriesData collectionFinal reportCessna 172 · Woodbine, NJThe student pilot's improper landing flare, which resulted in a porpoised landing.NTSB ERA17LA054Accident · No injuriesClass 3 · LimitedFinal reportLoofbourrow John W Rutan Defiant · Morristown, NJA collapse of the nose landing gear due to wear in the landing gear extension system.NTSB ERA16FA325Accident · 2 fatalField investigationFinal reportMooney M20J · Pittstown, NJThe pilot's improper landing touchdown attitude, which resulted in a propeller strike, and his inappropriate decision to abort the landing after the propeller had contacted the runway, which resulted in a loss of thrust and led to an aerodynamic stall during…NTSB GAA16CA314Accident · No injuriesData collectionFinal reportPiper PA 32 · Lincoln Park, NJThe airplane struck a deer during the landing flare resulting in substantial damage.NTSB GAA16CA340Accident · No injuriesData collectionFinal reportCessna 172 · Lumberton, NJThe pilot's hard landing, resulting in a runway excursion and substantial damage to the firewall.NTSB GAA16CA108Accident · No injuriesData collectionFinal reportCessna 180 · Sussex, NJThe student pilot's failure to maintain pitch control during the landing, which resulted in abnormal runway contact, a ground loop, and a nose over.NTSB ERA14CA394Accident · No injuriesData collectionFinal reportNorth American SNJ-6 · Readington, NJThe pilot's failure to maintain aircraft control during landing which resulted in an aircraft nose-over.NTSB DCA13FA094Accident · No injuriesField investigationFinal reportBombardier DHC8 · Newark, NJthe frozen left main landing gear (MLG) uplock roller due to lack of lubrication and the uplock latch that had worn beyond acceptable tolerances, which prevented the flight crew from extending the left MLG using the alternate extension system. Contributing to…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 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 ERA11CA280Accident · No injuriesData collectionFinal reportBombardier BD700 1A10 · Teterboro, NJThe pilot's loss of aircraft control during landing in gusty wind conditions.NTSB ERA09CA437Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Lincoln Park, NJThe pilot's improper flare, which resulted in a bounced landing, and the subsequent collapse of the landing gear.NTSB ERA09CA190Accident · No injuriesData collectionFinal reportPiper PA-42 · Belmar, NJThe pilot's improper flare, which resulted in a hard landing.NTSB MIA08CA194Accident · No injuriesData collectionFinal reportGlasflugel H-301 · Blairstown, NJThe pilot's inadvertent retraction of flaps during the landing flare.NTSB NYC08CA118Accident · No injuriesData collectionFinal reportCessna 172SP · Lincoln Park, NJThe certificated flight instructor's delayed decision to go-around.