NTSB investigations, NJ
14 cases where NTSB found Planning/preparation.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
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 c.\"eventStateOrRegion\" = 'NJ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020610'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020610')) 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 CEN17MA183Accident · 2 fatalClass 1 · MajorFinal reportLearjet 35A · Teterboro, NJThe pilot-in-command's (PIC) attempt to salvage an unstabilized visual approach, which resulted in an aerodynamic stall at low altitude. Contributing to the accident was the PIC's decision to allow an unapproved second-in-command to act as pilot flying, the…NTSB ERA17FA052Accident · 1 fatalField investigationFinal reportRyan Navion · New Gretna, NJThe pilot's inadequate preflight weather planning and in-flight weather evaluation, which resulted in an encounter with a strong cold front and the pilot's subsequent loss of airplane control.NTSB ERA16CA203Accident · No injuriesData collectionFinal reportBeech F33A · Fairfield, NJThe pilot's failure to adequately manage the available fuel supply, resulting in fuel starvation and a total loss of engine power.NTSB ERA15FA348Accident · 1 fatalField investigationFinal reportAerofab Lake LA-4-250 · Somerset, NJThe pilot's attempted 180-degree return to the runway immediately after takeoff in dark night conditions, which resulted in collision with trees and terrain. Also causal was the pilot's inadequate preflight inspection, which resulted in a takeoff with…NTSB ERA14LA342Accident · Serious injuriesLimited investigationFinal reportHolmlund Victor P Auriga · Manville, NJThe pilot’s improper preflight fuel planning and in-flight fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA13FA259Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Linden, NJThe flight instructor's inadequate preflight planning and his decision to take off with the airplane at a high gross weight in high temperature conditions that degraded the engine’s available power and his subsequent failure to maintain airspeed while…NTSB ERA12LA482Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation while maneuvering.NTSB ERA12LA470Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Farmingdale, NJThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA11CA225Accident · Serious injuriesData collectionFinal reportPiper PA38 · Manville, NJThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel starvation.NTSB ERA10FA202Accident · 1 fatalField investigationFinal reportCessna 172E · West Milford, NJThe complete loss of engine power due to fuel starvation.NTSB ERA09LA459Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Sussex, NJThe pilot’s improper pre-flight planning and take off over gross weight limits.NTSB CHI08LA215Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Rio Grande, NJA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.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 MIA08CA072Accident · No injuriesData collectionFinal reportEurocopter France AS350B1 · Linden, NJThe pilot's improper preflight preparation and his failure to maintain control of the helicopter.