NTSB investigations, NJ
20 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2002 | 2 |
| 2003 | 1 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 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 c.\"eventStateOrRegion\" = 'NJ' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 354)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 354) 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 NYC07LA192Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Frenchtown, NJA partial loss of engine power for undetermined reasons.NTSB NYC07CA133Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Lumberton, NJThe flight instructor's improper decision to simulate an engine failure in the traffic pattern by cutting off fuel to the engine, and his subsequent failure to maintain directional control during an aborted landing.NTSB NYC06LA187Accident · 1 fatalLimited investigationFinal reportBurleigh SeaRey · Ringoes, NJThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall. Factors included a partial loss of engine power for undetermined reasons.NTSB NYC06LA167Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Toms River, NJCarburetor icing, and the pilot's delayed application of carburetor heat, which resulted in a loss of engine power, and subsequent force landing. A factor in the accident was carburetor icing conditions.NTSB NYC05LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Caldwell, NJThe pilot's improper flare, which resulted in a hard landing. A factor was a partial loss of engine power, as reported by the pilot, for undetermined reasons.NTSB IAD05LA080Accident · 2 fatalLimited investigationFinal reportNavickas Load Runner 2000 · Hammonton, NJThe pilot's inadequate in-flight decision, which resulted in fuel exhaustion and subsequent loss of engine power. A factor was the wooded area, into which, the pilot had to autorotate.NTSB NYC03LA109Accident · No injuriesLimited investigationFinal reportCessna 175A · Ocean City, NJA partial loss of engine power for undetermined reasons.NTSB NYC02FA200Accident · 1 fatalField investigationFinal reportMooney M20E · West Creek, NJThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, and his failure to maintain airspeed.NTSB NYC02FA138Accident · Serious injuriesField investigationFinal reportYakovlev YAK 52 · Matawan, NJThe pilot's excessive maneuvering and failure to maintain aircraft control, following a partial power loss during the initial climb, which resulted in an inadvertent stall/spin. A factor in the accident was an inadequate annual condition inspection performed…NTSB NYC99LA185Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Manville, NJThe pilot's failure to follow the checklist and improper use of the carburetor heat. A factor in the accident was determined to be the density altitude.NTSB NYC97LA136Accident · No injuriesLimited investigationFinal reportCessna 172P · Wildwood, NJThe pilot's inadequate use of carburetor heat, which resulted in carburetor icing.NTSB BFO94LA079Accident · Serious injuriesLimited investigationFinal reportPitts S2B · Williamstown, NJthe pilot's failure to accurately determine the fuel supply, which resulted in fuel exhaustion and a subsequent forced landing.NTSB NYC92LA096Accident · No injuriesLimited investigationFinal reportCessna 140A · Vincentown, NJThe loss of engine power for undetermined reasons resulting in a collision with wires during a forced landing.NTSB BFO92FA022Accident · 1 fatalField investigationFinal reportHughes 369D · Edison, NJThe blockage of the fuel nozzle which resulted in partial loss of engine power. Contributing was the pilot's failure to maintain rotor RPM.NTSB NYC91FA218Accident · 1 fatalField investigationFinal reportCessna 150M · Marlboro, NJThe pilot's improper aircraft handling which resulted in an inadvertent stall and loss of control at an altitude insufficient for recovery. Factors related to the accident were an engine failure due to fuel exhaustion and improper preflight preparation.NTSB NYC89LA096Accident · No injuriesLimited investigationFinal reportBell 206B · Harding Twnp, NJThe pilots attempt to conduct the flight with less than required fuel resulting in loss of engine power and subsequent damage to the helicopter while performing an autorotative landing.NTSB NYC87FA215Accident · 4 fatalField investigationFinal reportCessna 182Q · Sparta, NJThe acft was observed to fly near power lines, then roll inverted, crash & burn in a wooded area. The 4 occupants rcvd multiple impact injuries which were fatal. The acft was destroyed by the impact & post crash fire. Svrl witnesses rprtd the eng power was…NTSB NYC84LA317Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Medford, NJDuring engine run-up, right magneto had excessive RPM drop. Plt leaned mixture for burn-out and inavvertently shut down engine. After restart, plt ran engine with lean mixture; subsequent magneto check was within limits. At 300 ft AGL on initial climb, engine…NTSB NYC84LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Hackettstown, NJAccording to the plt, he made an extended pattern to keep spacing on a slower acft that was landing. He stated that he went thru the landing checklist & everything seemed normal. On final apch, the acft got a little low, but when the throttle was advanced,…NTSB NYC82DA152Accident · No injuriesFinal reportEnstrom F28A · Hammonton, NJThe pilot performed an autorotation when the aircraft's engine lost power. Examination revealed no preimpact malfunction or failure.