NTSB investigations, ID
16 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 3 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 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\" = 'ID' 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\" = 352)
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" = 'ID' 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" = 352) 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 SEA04LA065Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Nezperce, IDThe circumferential fracture of the number seven cylinder head while en route to an aerial fertilizer application, leading to a forced landing on soft terrain, resulting in the collapse of the right main gear leg. Factors include soft terrain at the location…NTSB SEA03LA146Accident · No injuriesLimited investigationFinal reportCessna 182S · Henry's Lake, IDA set of inadequately torqued vacuum pump retaining nuts, leading to the failure of the vacuum pump gasket, resulting in oil exhaustion, which resulted in a loss of engine power during cruise. A ditch and rough uneven terrain were factors.NTSB SEA02LA121Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Shelley, IDA loss of engine power due to the manufacturer's improperly machined threads, which prevented the cylinder base/head halves from being properly assembled, leading to fatigue propagation and the ultimate separation of the cylinder. A contributing factor was…NTSB SEA99LA107Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · New Plymouth, IDLoss of engine power due to failure of the supercharger impeller. A contributing factor was the ditch.NTSB SEA98FA077Accident · No injuriesField investigationFinal reportGarlick UH-1H · Hope, IDFailure of a misaligned main bearing in the engine. Factors include returning a previously unairworthy-tagged engine to service by the operator's maintenance personnel without sufficient information to identify and correct an unknown engine deficiency.NTSB SEA96LA155Accident · No injuriesLimited investigationFinal reportGrumman G-164A · New Plymouth, IDa cracked cylinder head, which resulted in partial loss of engine power during takeoff. Factors relating to the accident were: the pilot allowed the gross weight of the airplane to be exceeded, and tall wheat (crop) in the emergency landing area.NTSB SEA95LA177Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Boise, IDimproper adjustment of the engine fuel control units by company maintenance personnel which led to excessive fuel flow and subsequent partial loss of engine power. Factors contributing to the accident were the rough terrain and high density altitude.NTSB SEA95LA165Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Buhl, IDThe loss of power due to the failure of an engine cylinder. The chemical load was not dumped for undetermined reasons and contributed to the severity of injuries.NTSB SEA95LA154Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roberts, IDA loss of engine power due to the separation of the number 3 cylinder exhaust valve rocker arm shaft from the cylinder head, which disabled movement of the exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB SEA93LA120Accident · No injuriesLimited investigationFinal reportCessna 185A · Lowell, IDFatigue of the rocker arm and unsuitable terrain which was encountered during the precautionary landing.NTSB SEA91LA139Accident · Minor injuriesLimited investigationFinal reportCessna 180G · Challis, IDThat the pilot encountered unsuitable terrain during a forced landing after a power loss due to a fractured cylinder boss and a bent engine pushrod.NTSB SEA89LA071Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Grangeville, IDA partial power loss due to a blower failure. A factor related to the accident was the soft field condition.NTSB SEA85LA214Accident · Minor injuriesLimited investigationFinal reportBell 206BII · Atlanta, IDA loss of pwr occurred shortly before touchdown. The left skid struck a rock during touchdown causing the acft to roll onto its right side. Twenty-five flt hrs prior to this flt an identical situation occurred and a loose air line to the fuel control was…NTSB SEA85LA178Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Idaho City, IDWhile the student plt was on a x-country flt, the eng lost power after the supercharger failed. The plt stated that he was unable to maintain altitude & RPM; he subsequently made a forced landing in a heavily timbered, mountainous area.NTSB SEA84LA199Accident · No injuriesLimited investigationFinal reportRockwell Thrush SR2 · Nampa, IDThe acft began to lose power while engaged in aerial application so the plt dumped his load and headed for the airstrip. Enroute the power deteriorated so the plt elected to land. Cutting the mixture gave the engine a surge which caused an overshoot into…NTSB SEA83LA043Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Pocatello, IDDuring a missed approach a partial power loss occurred during the transition to climb. The plt executed a course reversal to return visually to the arpt. Shortly thereafter he chose to execute an emergency landing on a frontage road which paralleled rr…