NTSB investigations, NJ
21 cases where the sequence of events included Nose over/nose down.
Cases per year
| 2011 | 1 |
|---|---|
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 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\" = '096' 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" = '096' 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 ERA24LA225Accident · Minor injuriesClass 4 · LimitedFinal reportNickle C R Acro II · Milford, NJThe pilot’s lack of familiarity with the airplane’s fuel system, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23LA333Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Port Norris, NJThe pilot’s improper fuel management, which resulted in fuel starvation and a total loss of engine power.NTSB ERA21LA375Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Andover Township, NJThe student pilot's excessive asymmetrical application of the brakes, which resulted in a nose over.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 ERA20CA113Accident · No injuriesData collectionFinal reportLearjet 55 · Farmingdale, NJThe flight crew's failure to stop the airplane on the available runway, which was wet and resulted in the airplane impacting a ditch.NTSB ERA19LA199Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12 · Readington, NJThe pilot's failure to land on the mowed turf runway, which resulted in the airplane landing in tall grass and subsequently nosing over.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 ERA17LA205Accident · Minor injuriesLimited investigationFinal reportCessna P206 · West Creek, NJThe pilot's improper fuel management, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB GAA17CA339Accident · No injuriesData collectionFinal reportCessna 180 · Belmar, NJThe pilot’s failure to maintain directional control while landing in gusting wind conditions.NTSB GAA17CA080Accident · No injuriesData collectionFinal reportCessna 172 · Woodbine, NJThe student pilot's improper landing flare, which resulted in a porpoised landing.NTSB GAA16CA400Accident · No injuriesData collectionFinal reportCessna 172 · Morristown, NJThe pilot's failure to maintain a safe taxi distance from a large turbine-powered airplane, resulting in an encounter of the turbine-powered airplane's jet blast while taxiing.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 GAA15CA035Accident · No injuriesData collectionFinal reportCessna 152 · Farmingdale, NJThe pilot's improper flare which resulted in a loss of control and subsequent hard landing.NTSB ERA15LA071Accident · Minor injuriesLimited investigationFinal reportCessna 210 5(205) · Sussex, NJMaintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.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 ERA14CA204Accident · No injuriesData collectionFinal reportCessna A185E · Somerville, NJThe pilot's failure to maintain directional control while landing in a gusty crosswind.NTSB ERA14CA118Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Sussex, NJThe pilot's improper preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA14CA012Accident · No injuriesData collectionFinal reportClassic Waco YMF · Somerville, NJThe pilot's failure to maintain aircraft control while applying wheel brakes during landing roll resulting in the airplane nosing over.NTSB ERA12CA533Accident · Minor injuriesData collectionFinal reportStearman M-2 · Robbinsville, NJThe pilot's failure to maintain directional control during the landing roll.NTSB ERA12CA427Accident · No injuriesData collectionFinal reportCessna 182A · Sussex, NJThe pilot’s delayed decision to abort the landing and perform a go-around, which resulted in a runway overrun.NTSB ERA11CA358Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Linwood, NJThe pilot's improper brake application during the landing roll which resulted in a nose over.