NTSB investigations, 2008, NJ
12 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 10 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 9 |
| 2013 | 7 |
| 2014 | 10 |
| 2015 | 7 |
| 2016 | 8 |
| 2017 | 13 |
| 2018 | 10 |
| 2019 | 4 |
| 2020 | 2 |
| 2021 | 5 |
| 2022 | 5 |
| 2023 | 3 |
| 2024 | 4 |
| 2025 | 3 |
| 2026 | 2 |
Where
Latest 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 year(c.\"eventDate\") = 2008
AND 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\" = '470' 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 year(c."eventDate") = 2008 AND 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" = '470' 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 ERA09FA100Accident · Serious injuriesField investigationFinal reportBeech C23 · Linden, NJA partial loss of engine power for undetermined reasons.NTSB MIA08LA166Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche P2002 Sierra · Woodbine, NJThe student pilot's failure to maintain airspeed during a go-around. Contributing to the accident was the student pilot's degraded emotional/mental state due to stress.NTSB NYC08CA250Accident · No injuriesData collectionFinal reportCessna 172 N · Williamstown, NJThe student pilot's inability to maintain directional control during the attempted aborted landing. Contributing to the severity of the accident were the trees.NTSB MIA08CA140Accident · Minor injuriesData collectionFinal reportQuad City Ultralight Challenger II · Windslow Twp, NJThe pilot's inaccurate fuel consumption calculations which led to fuel exhaustion and subsequent loss of engine power.NTSB NYC08CA233Accident · No injuriesData collectionFinal reportCessna T182T · Lincoln Park, NJThe pilot's failure to maintain aircraft control while landing. Contributing to the accident was the wet runway and hydroplaning conditions.NTSB NYC08LA228Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Toms River, NJThe failure of the pilot's seat to engage or remain engaged due to the improper inspection of the worn seat tracks.NTSB NYC08LA224Accident · 2 fatalLimited investigationFinal reportAero Vodochody Aero. Works L-29 Delfin · Millville, NJA total loss of engine power due to fuel starvation as a result of a clogged fuel filter that was not identified due to the pilot's inadequate preflight inspection.NTSB NYC08LA222Accident · 2 fatalLimited investigationFinal reportDennis P. McGurk F1 Rocket · Woodbine, NJA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the proper tank prior to performing aerobatics.NTSB NYC08CA200Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Wildwood, NJThe pilot's failure to maintain clearance from trees during approach. Contributing to the accident were the dark night conditions.NTSB ANC08CA069Accident · No injuriesData collectionFinal reportCessna 421 · Caldwell, NJThe pilot's failure to maintain directional control while landing. Factors in the accident were a hydroplaning condition, and a wet runway.NTSB NYC08CA181Accident · No injuriesData collectionFinal reportCessna 172 M · Hampton, NJA loss of engine power for undetermined reasons.NTSB NYC08LA107Accident · Serious injuriesLimited investigationFinal reportChrister Vans RV9-A · Princeton, NJA loss of engine power due to the pilot/owner's improper installation of a new ignition/fuel control system for the engine. Contributing was the unsuitable terrain for a forced landing.