NTSB investigations, 1996
42 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 91 |
|---|---|
| 1983 | 77 |
| 1984 | 88 |
| 1985 | 82 |
| 1986 | 76 |
| 1987 | 58 |
| 1988 | 76 |
| 1989 | 67 |
| 1990 | 74 |
| 1991 | 62 |
| 1992 | 48 |
| 1993 | 53 |
| 1994 | 54 |
| 1995 | 60 |
| 1996 | 42 |
| 1997 | 43 |
| 1998 | 50 |
| 1999 | 35 |
| 2000 | 41 |
| 2001 | 28 |
| 2002 | 36 |
| 2003 | 24 |
| 2004 | 45 |
| 2005 | 33 |
| 2006 | 28 |
| 2007 | 37 |
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 year(c.\"eventDate\") = 1996
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 year(c."eventDate") = 1996 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 FTW97LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Raton, NMfailure of the exhaust rocker arm retaining studs due to over torquing of the attachment bolts by maintenance personnel during installation. A factor was the lack of suitable terrain for the forced landing.NTSB MIA97LA039Accident · No injuriesLimited investigationFinal reportWiedemann KIT FOX · Montgomery, ALimproper installation of a throttle cable clamp by an unknown person, resulting in a loose throttle cable housing and an inability to control the throttle position; and failure of the pilot to maintain adequate airspeed during an approach for an emergency…NTSB MIA97LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Sugarloaf Key, FLa complete loss of engine power due to a disconnected connecting rod cap.NTSB ANC97LA005Accident · No injuriesLimited investigationFinal reportKen Seright Rotorway Exec 162F · Haines, AKa leaking coolant hose that saturated the induction air filter and one electronic ignition system with coolant. Unsuitable terrain for a forced landing was a related factor in the accident.NTSB MIA97LA006Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Lexington, TNfailure of the pilot to abort the takeoff after encountering excessive ground roll, and failure (or inability) of the pilot to obtain/maintain adequate airspeed, which resulted in an inadvertent stall. Factors relating to the accident were: restricted…NTSB CHI97LA011Accident · Serious injuriesLimited investigationFinal reportAero Commander 685 · Eden, WIa partial loss of engine power due to improper adjustment of the fuel pump by an unqualified person (pilot-in-command) and the pilot's inadequate preflight planning which resulted in his selection of unsuitable terrain for the attempted takeoff. The pilot's…NTSB CHI97LA006Accident · Minor injuriesLimited investigationFinal reportCallair B1A · Nebraska City, NEa supercharger bearing failure. A factor was the excessive sink rate during the forced landing.NTSB LAX97LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Plymouth, CAfailure of the #3 exhaust valve, which resulted in loss of engine power, a forced landing, and subsequent collision with a fence post.NTSB ANC96FA162Accident · 3 fatalField investigationFinal reportCessna 206G · Anchorage, AKimproper installation of a connecting bolt in the throttle linkage, which resulted in a worn/disconnected throttle arm, partial loss of engine power, and a forced landing after takeoff.NTSB CHI96FA348Accident · 1 fatalField investigationFinal reportCessna 172F · Saint Clair, MNa loss of power due to the engine's #2 cylinder exhaust valve stuck open, and the pilot's failure to maintain airspeed.NTSB FTW96LA388Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Ferriday, LAThe partial loss of engine power due to a cracked cylinder head. Factors were the oil leak which restricted the pilot's visual lookout and the lack of suitable terrain for the forced landing.NTSB CHI96LA340Accident · No injuriesLimited investigationFinal reportCessna 150 · Wonder Lake, ILa blocked exhaust pipe as a result of an inadequate weld repair to the muffler.NTSB FTW96LA343Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Midlothian, TXmaintenance personnel's improper engine overhaul procedures resulting in the installation of the rocker arms in reversed positions, which led to improper lubrication and binding of the exhaust valves. A related factor was the lack of suitable terrain for the…NTSB LAX96LA299Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Caruthers, CAthe loss of engine power due to the failure of a cylinder. The road's soft surface was a factor.NTSB CHI96LA261Accident · No injuriesLimited investigationFinal reportCessna 188B · Cimarron, KSthe pilot's failure to make a timely decision to abort the takeoff or dump the payload.NTSB CHI96LA253Accident · No injuriesLimited investigationFinal reportYasecko LONG-EZE · Waukesha, WIFailure of the throttle cable.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 FTW96LA297Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Mcgehee, ARa loss of engine power and subsequent engine fire for undetermined reasons.NTSB CHI96LA236Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 Dromader · Waupaca, WIinadequate maintenance of the throttle cable by maintenance personnel.NTSB IAD96LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Harrisburg, PAFailure of the right engine due to a fatigue fracture of the crankshaft resultant from heat cracks from an undetermined source.NTSB SEA96LA144Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Mcminnville, ORimproper maintenance (replacement) and inspection of the engine fuel governor by company maintenance personnel, the pilot's inadequate preflight inspection, and a subsequent disconnect of the adjustable governor lever control rod, which disabled the engine…NTSB CHI96FA216Accident · No injuriesField investigationFinal reportFairchild SA227AC · Grand Forks, NDinsufficient clearance between the second stage compressor impeller and the shroud. A factor was the subsequent fatigue failure of the impeller.NTSB ATL96FA095Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Clanton, ALcorrosion pitting of the number six cylinder on the left engine, and subsequent fatigue fracture and separation of the cylinder, which led to an engine compartment fire, wing fire, and an in-flight separation of the left wing.NTSB IAD96LA087Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · New Market, VAa loss of engine power as a result of the failure of the left exhaust tailpipe and led to a shorted ignition system. A related factor was the unsuitable terrain in which the aircraft landed.NTSB LAX96LA210Accident · No injuriesLimited investigationFinal reportRotorway Exec 9 · Chandler, AZa loss of engine power due to a failed piston and piston ring in a critical phase of flight.NTSB MIA96LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Jacksonville, FLThe pilot's failure to maintain airspeed (VSO) while maneuvering during a go-around, resulting in an inadvertent stall and subsequent in-flight collision with terrain. Contributing to the accident was the pilot's failure to achieve the proper touchdown point…NTSB NYC96LA105Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Vineland, NJfailure of the number 8 cylinder, which resulted in loss of engine power, a forced landing in soft terrain, and subsequent nose over of the airplane.NTSB MIA96GA138Accident · 1 fatalFinal reportWsk Pzl Mielec M18A · Kinston, NCa cracked/fractured #5 cylinder and subsequent failure/jamming of the #5 exhaust valve, which resulted in a partial loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall and collision with the terrain. Factors…NTSB CHI96FA146Accident · 3 fatalField investigationFinal reportCessna 421 · Bernard, IAthe pilot's operation of the airplane with known deficiencies, subsequent loss of oil from the left engine, and the pilot's failure to maintain minimum controllable airspeed (VMC), while diverting to an alternate airport. Factors relating to the accident…NTSB LAX96LA180Accident · No injuriesLimited investigationFinal reportCessna 320 · Mammoth Lakes, CAthe partial failure of the right engine turbocharger wastegate butterfly valve to fully close due to mechanical binding and the low setting of its associated absolute pressure controller. A related factor was the high density altitude which reduced the…NTSB ANC96FA059Accident · 1 fatalField investigationFinal reportCessna 150 · Palmer, AKloss of engine power due to a malfunction of the airplane's magneto ignition system, and the pilot's failure to have an annual inspection performed. Factors relating to the accident were: the pilot's lack of recent experience and inadequate in-flight planning…NTSB LAX96LA167Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Lake Havasu Cty, AZthe pilot-owner's inadequate engine maintenance which resulted in a progressive ignition failure. Factors which contributed to the accident were the dark nighttime light condition and the presence of hidden obstructions in the forced landing area.NTSB CHI96LA132Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Anoka, MNA loose exhaust system that had become disconnected and blocked, which resulted in partial loss of engine power.NTSB LAX96LA152Accident · 1 fatalLimited investigationFinal reportPowell Glasair · Groveland, CAthe pilot's decision to fly the aircraft with a known mechanical discrepancy in the throttle linkage, which resulted in a partial loss of engine power; and his failure to maintain an adequate airspeed while maneuvering for an emergency landing, which resulted…NTSB IAD96LA049Accident · Minor injuriesLimited investigationFinal reportKitfox IV-1200 · Saluda, VAa partial loss of engine power due to spark plug failure, and the pilot's evasive maneuver to avoid lights at the end of the runway.NTSB FTW96LA134Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Austin, TXthe partial loss of engine power due to the failure of the #3 connecting rod. A factor was the lack of suitable terrain for the forced landing.NTSB MIA96LA095Accident · No injuriesLimited investigationFinal reportRotor Flight Dynamics Dominator · Quincy, FLa partial loss of engine power due to fuel contamination, and the pilot-in-command's improper decision to land with a tailwind.NTSB FTW96LA098Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Las Vegas, NMfailure of the throttle cable. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB CHI96LA072Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Pleasant, MIthe student pilot's inadequate preflight and the loose oil filler cap, which resulted in oil starvation and failure of the #1 cylinder connecting rod. A factor relating to this accident was the snow covered terrain.NTSB SEA96LA042Accident · No injuriesLimited investigationFinal reportCessna 182 · Grantsville, UTthe failure of the #5 exhaust valve rocker boss, and the subsequent sticking of the exhaust valve in the closed position. Factors include wet, soft terrain in the only available landing area.NTSB LAX96LA085Accident · 1 fatalLimited investigationFinal reportKlingberg Miniplane DSA-1 · El Cajon, CAthe pilot's intentional operation of the aircraft with known mechanical deficiencies in the engine, and his failure to maintain an adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall/spin.NTSB LAX96IA087Incident · No injuriesIncident investigationFinal reportBoeing 747-251B · Los Angeles, CAThe fatigue fracture of the number 4 bearing oil pressure tube due to an improper maintenance cleaning procedure by company maintenance personnel.