NTSB investigations, NH
13 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2005 | 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\" = 'NH' 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" = 'NH' 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 NYC06FA027Accident · Serious injuriesField investigationFinal reportEmbraer 110P1 · Manchester, NHThe pilot’s misapplication of flight controls following an engine failure. Contributing to the accident was the failure of the sun gear, which resulted in the loss of engine power. Contributing to the sun gear failure were the engine manufacturer’s…NTSB NYC02LA002Accident · Minor injuriesLimited investigationFinal reportBeech C-45H · Hudson, NHThe pilot/owner's failure to properly identify the inoperative engine prior to feathering the wrong propeller, and his lack of familiarity with the required corrective procedures. A factor was the initial engine failure.NTSB IAD99FA025Accident · 1 fatalField investigationFinal reportLake LA-4-250 · Laconia, NHA loss of engine power during initial climb due to oil starvation. Contributing to the accident was the failure to perform an engine overhaul.NTSB NYC96LA001Accident · No injuriesLimited investigationFinal reportCheney Avid Flyer · Newton, NHThe seizure of a piston during the takeoff climb, resulting in a loss of engine power, forced landing, and subsequent collision with trees.NTSB NYC95LA183Accident · No injuriesLimited investigationFinal reportBeech C23 · Dublin, NHThe loss of engine power due to improper major overhaul of the engine by the reuse of worn piston pins. The rough/ uneven terrain in the emergency landing area was a factor.NTSB NYC95LA028Accident · No injuriesLimited investigationFinal reportRans/Hine S-10 · Hampton, NHa seized piston in the foward cylinder due to a lean mixture.NTSB NYC95LA004Accident · No injuriesLimited investigationFinal reportCessna 182N · New London, NHthe failure of the number four push rod, which resulted in the complete loss of engine power and forced landing, and the subsequent nose over on soft terrain.NTSB NYC91DNC04Accident · Minor injuriesFinal reportLaurent A. Cloutier BD-5B · Gilford, NHEngine failure due to a faulty oil pressure relief valve resulting in an emergency landing on unsuitable terrain.NTSB NYC88LA117Accident · No injuriesLimited investigationFinal reportMooney M20 · Manchester, NHMaintenance personnel improperly installed the number two connecting rod (p/n L-10646) causing it to separate, create a hole in the engine case, loss of engine oil and engine power. Due to the pilot's improper inflight decision, he performed a wheels up…NTSB NYC87DNC01Accident · No injuriesFinal reportEnstrom F-28A · Belmont, NHThe helicopter was in cruise flt when an engine failure occurred. The plt entered an autorotation and made a hard landing which collapsed the left front strut. The nose lowered as the tail cone rose and the main rotor made contact with the tail rotor. The…NTSB NYC86LA090Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Laconia, NHDuring cruise flt, the acft eng failed & oil covered the windshield & side windows. Subsequently, the acft crash landed into wooded terrain while in a wings level attitude at low speed. Tests showed the eng crankshaft had failed from fatigue. The fatigue…NTSB NYC85LA005Accident · No injuriesLimited investigationFinal reportBell 47G3-B1 · Moultonboro, NHAcft was climbing through a mountain saddle when the engine began to backfire and lose power. Plt entered autorotation & settled into trees on autorotative flare. Engine inspection revealed #3 cylinder intake valve springs broken.NTSB NYC84FA009Accident · 1 fatalField investigationFinal reportBell 206B III · Hudson, NHThe plt was on a flt to pick up film for a tv station. While en route, he made a mayday call to the manchester control tower. According to witnesses, the acft was proceeding in a northerly direction at about 700 to 1000 ft AGL when they heard a 'muffled pop.'…