NTSB investigations, NJ
29 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351)
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" = 351) 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 NYC07LA146Accident · No injuriesLimited investigationFinal reportBell-Carson 47G-Super C-4 · Wall Township, NJA total failure of the number one connecting rod during approach.NTSB NYC07LA001Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hammonton, NJDisplacement of the idler gear assembly, which resulted in a loss of camshaft timing, and a subsequent engine failure. Contributing to the accident was the swampy terrain condition.NTSB NYC06LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-180 · Lincoln Park, NJThe improper installation of the helicoil by the non-certificated mechanic, and the inadequate inspection of the installation by the certificated mechanic.NTSB IAD05LA077Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Southampton, NJA lack of lubrication for undetermined reasons which resulted in the failure of the Nos. 4 and 5 connecting rods, and a subsequent total loss of engine power. A factor in the accident was the furrowed cornfield.NTSB NYC03LA048Accident · No injuriesLimited investigationFinal reportCessna 172SP · Flemington, NJThe manufacturer's improper assembly of the accessory drive section of the engine.NTSB NYC03FA008Accident · Minor injuriesField investigationFinal reportPilatus PC-12/45 · Trenton, NJA power loss, due to failure of the No. 1 bearing, which was a result of previous electrical discharge damage (EDD). Factors were the low ceiling and a wet runway.NTSB IAD02FA091Accident · 2 fatalField investigationFinal reportPiper PA 32R-301T · Byram Township, NJthe improper manufacturing of the crankshaft gear bolt, which resulted in the failure of the bolt due to hydrogen embrittlement, and the subsequent loss of engine power. Also causal was the engine manufacturer's failure to remove the affected bolts from fixed…NTSB NYC00IA250Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-30 · Newark, NJThe sequential failure of the 2nd-stage low pressure turbine nozzle locks, which allowed the 2nds stage turbine nozzle segments to rotate within the low pressure turbine case, machining a hole whereby the nozzle segments exited the engine. A factor was the…NTSB NYC00LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Toms River, NJThe failure of the number 9 cylinder connecting rod, due to a primer leak initiation of a partial hydraulic lock. A factor in the accident was the unsuitable terrain, to which the forced landing had to be made.NTSB NYC99LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Andover, NJFatigue failure of the crankshaft.NTSB NYC99FA078Accident · 1 fatalField investigationFinal reportDeleeuw Sprint 1000 · Lakewood, NJThe pilot's loss of control, which resulted in an unintentional stall/spin after an engine failure. A factor in the accident was the engine failure, which occurred when the magneto piston seized within the cylinder sleeve during an overtemp event.NTSB NYC98LA168Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-1A · Erial, NJCatastrophic failure of the number 2 engine cylinder, emanating from a corrosion pit on the outside cylinder wall. A factor was the pilot's diminished forward visibility due to oil on the windshield.NTSB NYC96LA118Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Williamstown, NJinadequate maintenance, which resulted in a failure of the magneto housing hold-down flange, a disconnect of the magneto from the engine, and loss of engine power. The obstruction (fence post) in the emergency landing area was a related factor.NTSB NYC95LA110Accident · 1 fatalLimited investigationFinal reportHighcraft Buccaneer II · Millstone Twsp, NJThe loss of engine power due to the seizure of the number one cylinder pistion and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB NYC95LA099Accident · No injuriesLimited investigationFinal reportEurocopter AS350D · Sea Bright, NJFailure of the position 19 engine bearing, which resulted in shifting of the accessory gear drive, disengagement of the fuel pump, fuel starvation, and loss of engine power.NTSB NYC91FA199Accident · 3 fatalField investigationFinal reportBeech C23 · Pleasantville, NJA power loss due to a failed crankshaft, while operating over unsuitable terrain. Factors related to the accident were, the night conditions, the failure of maintenance personnel to detect the cracks using magnaflux inspections, the lack of adequate…NTSB NYC91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Lumberton, NJThe pilot's failure to maintain airspeed and the resultant inadvertent stall. A factor in the accident was the loose oil filter.NTSB NYC90DHD03Accident · Minor injuriesFinal reportHeinrichs Rand KR-2 · Barnegat, NJThe loss of engine power due to magneto failure.NTSB NYC90FA156Accident · No injuriesField investigationFinal reportBell 206 B3 · Teterboro, NJFailed power turbine shaft. Factors in the accident were corrosion on the power turbine shaft and inadequate manufacturer's service bulletins.NTSB NYC90FA038Accident · No injuriesField investigationFinal reportBoeing 727-31 · Newark, NJThermal distress of the first stage turbine blades of the nuber one engine causing a degradation of material properties which resulted in blade fractures. The reason for the thermal distress was not determined.NTSB NYC89IA005Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Newark, NJThe #3 eng suffered an uncontained turbine blade failure during a takeoff roll. The takeoff was aborted at 120 KTS without further incident. Investigation revealed that all 12 tierods for the 2nd stage low compressor suffered a progessive failure. This…NTSB NYC88LA203Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Wildwood, NJThe aircraft struck a building after if experienced a power loss due to fuel exhaustion caused by oil dilution and low engine compression.NTSB NYC87LA144Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Caldwell, NJDrg a ngt takeoff, the eng lost pwr shortly after lift-off & the plt chose an area away from bldgs & obstructions for an emerg landing. However, drg the landing, the acft was extensively damaged. An exam revealed the rgt fuel tank was empty & the left tank…NTSB NYC87LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Old Bridge, NJThe Cessna 152 took off and after becoming airborne, experienced a total loss of power. The student pilot who had made the takeoff turned control of the aircraft over to the flight instructor, who made an emergency landing in a drag strip parking lot which…NTSB NYC86LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wayne, NJThe aircraft developed engine problems while on approach to the airport at caldwell, new jersey and collided with trees during the forced landing. Upon examination of the aircraft, debris was found in the vent line from the fuel vent tube to the left fuel…NTSB NYC85LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lakewood, NJWhile returning to Lakewood airport,, power was lost suddenly. The pilot elected to land in a stand of pine and oak trees instead of landing on a busy highway. The pilot decided that the distance was too great for a glide to the airport. A post crash…NTSB NYC84MA270Accident · 1 fatalMajor investigationFinal reportSikorsky S-76A · Fort Dix, NJThe aircrew of the helicopter contacted mcguire rapcon & obtained clearance to proceed thru the mcguire afb control zone at 1500 ft. a short time later, the crew declared an emergency. Witnesses on the ground heard a loud 'bang' & observed the helicopter…NTSB NYC83FA045Accident · 1 fatalField investigationFinal reportCessna 182N · Ringwood, NJThe plt declared an emergency due to power loss & the acft crashed into a reservoir. Engine examination disclosed numerous pieces of the induction air filter throughout the engine. Filter paper was found lodged between the intake valve & valve seat of the #5…NTSB NYC82DA206Accident · No injuriesFinal reportBell 206L-1 · Ho Ho Kus, NJWhile in straight and level flight at 1000 ft, the pilot heard a "pop" in the engine area. He noted that the turbine outlet temperature (tot) began an immediate rise to the high yellow area initially, the power was reduced to 50% torque and the tot returned…