NTSB investigations, AK
143 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 9 |
| 1984 | 13 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 7 |
| 1988 | 8 |
| 1989 | 8 |
| 1990 | 10 |
| 1991 | 10 |
| 1992 | 6 |
| 1993 | 3 |
| 1994 | 6 |
| 1995 | 4 |
| 1996 | 7 |
| 1997 | 7 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 1 |
| 2003 | 3 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 3 |
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\" = 'AK' 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" = 'AK' 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 ANC07LA104Accident · Minor injuriesLimited investigationFinal reportCessna U206 · McGrath, AKA separation of the engine connecting rod and engine cylinder due to the loss of a connecting rod nut that was stripped from the rod bolt.NTSB ANC07LA085Accident · No injuriesLimited investigationFinal reportCessna 207 · Fairbanks, AKThe loss of engine power in cruise flight due to a lack of sufficient oil. A factor contributing to the accident was the pilot's improper in-flight decision to continue the flight after noting a loss of oil pressure.NTSB ANC07FA013Accident · 1 fatalField investigationFinal reportCessna 207A · Kenai, AKThe total loss of engine power during cruise flight due to the disintegration of engine bearings and the fracture of a connecting rod, which resulted in a ditching into ice covered ocean water. Factors contributing to the survivability of the accident were…NTSB ANC06LA144Accident · No injuriesLimited investigationFinal reportCessna TU206A · Juneau, AKThe separation of the number 6 cylinder assembly from the engine during cruise flight, which resulted in a hard forced landing in rough ocean swells. A factor contributing to the accident was the rough ocean swells.NTSB ANC06LA084Accident · No injuriesLimited investigationFinal reportBeech P35 · Gustavus, AKThe fracture of an engine connecting rod during cruise flight, which resulted in a forced landing on a beach, a collapsed nose landing gear, and substantial damage to the fuselage.NTSB ANC06LA005Accident · No injuriesLimited investigationFinal reportCrisenbery Northman 2+2 · Nenana, AKA loss of engine power during cruise flight due to a cracked oil filter housing and subsequent loss of engine oil, which resulted in a forced landing in trees.NTSB ANC05LA107Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350BA · Juneau, AKA loss of engine power during takeoff initial climb due to the separation of the engine power turbine shaft, the failure of which was due to a disconnected adjacent leaf spring, which resulted in an emergency landing after takeoff and subsequent hard landing.NTSB ANC04LA003Accident · Minor injuriesLimited investigationFinal reportFairchild 42 · Wasilla, AKThe inadequate inspection of the carburetor by the aircraft mechanic who had recently worked on the carburetor, which failed to detect a cracked float, resulting in a total loss of engine power during cruise flight. A factor associated with the accident was…NTSB ANC03LA091Accident · No injuriesLimited investigationFinal reportCessna 207A · Bethel, AKA complete loss of engine power during cruise flight due to the shifting of a main crankshaft bearing that produced a fatigue failure of the crankshaft. A factor contributing to the accident was unsuitable terrain for a forced landing, which resulted in a…NTSB ANC03LA073Accident · Minor injuriesLimited investigationFinal reportBell 206B · Aniak, AKThe compressor discharge pressure line (Pc line) B-nut coming loose at the fuel control unit, which resulted in a total loss of engine power, and subsequent in-flight collision with trees during an autorotation. A factor associated with the accident was the…NTSB ANC02LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKA total engine failure during cruise flight due to the disentegration of the number five cylinder piston. A contributing factor in the accident was the lack of suitable terrain for a forced landing.NTSB ANC01LA118Accident · No injuriesLimited investigationFinal reportThomson Avid Flyer · Chugiak, AKThe loss of engine power during initial climb due to a broken spark plug.NTSB ANC01FA095Accident · Serious injuriesField investigationFinal reportCessna 172 · Eagle River, AKThe fatigue induced fracture of a connecting rod wrist pin, resulting in a complete loss of engine power.NTSB ANC01IA058Incident · No injuriesIncident investigationFinal reportCessna 207 · Quinhagak, AKAn in-flight fracture of the engine crankshaft during descent, precipitated by restricted oil flow through an internal engine oil passage/port.NTSB ANC01LA050Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Glennallen, AKA total failure of the engine and subsequent rupture of the crankcase during cruise flight. A factor in the accident was unsuitable terrain for a forced landing.NTSB ANC00FA056Accident · No injuriesField investigationFinal reportBeech B24R · Anchorage, AKA fatigue failure of the crankcase through bolt, the separation of number 3 cylinder assembly, and the inadequate maintenance/service of the airplane by company maintenance personnel.NTSB ANC00LA035Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Delta Junction, AKThe disintegration of the number two piston. A factor in this accident was the subsequent metal fouling of the spark plugs, which resulted in total loss of engine power.NTSB ANC99LA114Accident · No injuriesLimited investigationFinal reportCessna 206A · Cordova, AKA loss of engine power due to corrosion/blockage of the fuel flow divider vent hole. A factor was unsuitable terrain for a forced landing.NTSB ANC99LA099Accident · No injuriesLimited investigationFinal reportBoeing 747-269B · Anchorage, AKThe failure of a turbine blade, and subsequent penetration of the shroud (containment ring). A factor associated with the accident was the FAA's insufficient design standards/requirements addressed in an FAA Air Worthiness Directive, which called for a…NTSB ANC99LA052Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Juneau, AKThe failure of the engine driven fuel pump for undetermined reasons. Factors associated with this accident were the low altitude at which the failure occurred resulting in task overload of the pilot, and landing the amphibious airplane in the swampy terrain…NTSB ANC99LA043Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · Fairbanks, AKThe loss of engine power due to the failure of maintenance personnel to properly torque a connecting rod bolt during an engine overhaul, and the subsequent disconnection of the connecting rod bolt and connecting rod.NTSB ANC98LA140Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbanks, AKThe loss of engine power due to an in-flight fracture of an engine exhaust valve stem assembly. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB ANC98LA078Accident · No injuriesLimited investigationFinal reportCessna 207 · Holy Cross, AKThe improper installation/undertorquing of the engine crankcase bolts by company maintenance personnel, and a subsequent fracture of the engine crankshaft. A factor in the accident was unsuitable terrain for a forced landing.NTSB ANC98LA041Accident · No injuriesLimited investigationFinal reportCessna 170B · Kenai, AKA failure of the number six cylinder rod bearing and connecting rod cap for undetermined reasons. Factors in the accident were snow covered terrain that was unsuitable for a forced landing.NTSB ANC97FA143Accident · 2 fatalField investigationFinal reportAero Commander AC-500A · Ketchikan, AKThe rupture of the right engine fuel supply line as a result of inadequate inspection by the pilot/mechanic, and the pilot's excessive pull up which resulted in exceeding the design stress limits of the airplane. Factors were the improper emergency procedures…NTSB ANC97LA112Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Palmer, AKA fatigue failure of the engine crankshaft, and an inadequate engine cylinder replacement by maintenance personnel. A factor in the accident was unsuitable terrain for a forced landing.NTSB ANC97FA097Accident · 4 fatalField investigationFinal reportPiper PA-32 · Skagway, AKjamming/failure of the left magneto impulse coupling, which stopped rotation of the magneto gear, and resulted in subsequent shearing of the accessory intermediate idler gear. Factors relating to the accident were: the lack of suitable terrain for a forced…NTSB ANC97LA084Accident · No injuriesLimited investigationFinal reportAnderson Kitfox IV-1200 · Fairbanks, AKa seized crankshaft connecting rod bearing. A factor relating to the acciden was: the lack of suitable terrain for an emergency landing.NTSB ANC97LA068Accident · No injuriesLimited investigationFinal reportHammer Avid Flyer · Chitina, AKimproper overhaul of the engine, which resulted in a seized piston and resultant loss of engine power. Rough terrain in the emergency landing area was a related factor.NTSB ANC97LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Alsworth, AKloss of engine power, due to failure of the number 2 connecting rod assembly (rod, bearing, & bolts). The lack of suitable terrain for a forced landing was a related factor.NTSB ANC97LA036Accident · Minor injuriesLimited investigationFinal reportWilliams Kitfox · Wasilla, AKa broken electrical wire, which resulted in an inoperative electrical fuel pump, an overly lean mixture, fuel starvation, and loss of engine power.NTSB ANC96LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Skwentna, AKcorrosion and subsequent fatigue failure of the crankshaft, which resulted in engine failure and a forced landing. Factors related to the accident were: the lack of suitable terrain for a forced landing, and the operator's non-compliance with a service…NTSB ANC96LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKAn engine failure due to an eroded engine piston. Factors in the accident were unsuitable terrain for a forced landing and improperly timed magnetos.NTSB ANC96LA103Accident · No injuriesLimited investigationFinal reportCessna 172XP · Kenai, AKThe loss of engine power due to seized piston connecting rod bearings, and subsequent failure of the piston connecting rod cap and fracture of the piston connecting rod. A factor associated with the accident was the rough and uneven emergency landing site.NTSB ANC96FA102Accident · 4 fatalField investigationFinal reportDouglas DC-6A · Russian Mission, AKfatigue failure of the master connecting rod, which originated from corrosion pitting, subsequently compromised the engine crankcase, and resulted in a fire; and failure of the flight crew to follow emergency procedures by pulling the fire handle before…NTSB ANC96TA095Accident · Minor injuriesFinal reportCessna 185 · Fairbanks, AKfatigue failure of the engine crankshaft. A factor related to the accident was: the lack of suitable terrain for a forced landing.NTSB ANC96LA088Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gustavus, AKA loss of engine power due to low fuel pressure from the engine driven fuel pump and subsequent fuel starvation. A factor was the lack of suitable terrain for a forced landing.NTSB ANC96LA053Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Grayling, AKdisintegration of the alternator drive coupling, jamming of the accessory drive gear, shearing of the oil pump drive, oil starvation, and failure of the number 6 cylinder connecting rod. Non-compliance with a manufacturer's service bulletin and soft snow were…NTSB ANC96LA017Accident · No injuriesLimited investigationFinal reportCessna 207 · Aniak, AKfatigue failure of the engine crankshaft at the number 2 main bearing journal, where rubbing contact had occurred with the number 2 main bearing. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB ANC95LA119Accident · 4 fatalLimited investigationFinal reportCessna 421C · Cordova, AKMechanical loss of engine power for undetermined reason(s), and subsequent in-flight collision with water (or ditching at sea).NTSB ANC95LA058Accident · No injuriesLimited investigationFinal reportCessna 206 · Bethel, AKA failure of the #2 main engine bearing and subsequent fatigue failure of the engine crankshaft. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.NTSB ANC95LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Chickaloon, AKThe fracture of the crankshaft resulting in separation of the propeller and propeller flange in-flight. A factor associated with the accident was the lack of suitable terrain for an emergency landing.NTSB ANC94FA106Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Kenai, AKInadequate engine maintenance and/or inspection, and fatigue cracking of the engine case, which resulted in eventual damage to the #3 cylinder studs/engine through-bolts, subsequent separation of the #3 cylinder and piston, and an in-flight fire.NTSB ANC94LA097Accident · No injuriesLimited investigationFinal reportCessna 206 · Mosquito Flats, AKThe missing number 6 cylinder piston pin cap and the subsequent failure of the number 6 cylinder connecting rod cap. Also, the lack of suitable landing area for the forced landing.NTSB ANC94LA095Accident · No injuriesLimited investigationFinal reportStarman Teirra II · North Pole, AKThe seizure of the no. 2 cylinder as a result of an inadequate cooling system for the high ambient temperature.NTSB ANC94LA078Accident · Serious injuriesLimited investigationFinal reportCessna T207 · Kenai, AKThe failure of the engine crankshaft. Factors in the accident were the pilot's inadequate compensation for the wind conditions and not attaining the proper touchdown point at the suitable landing strip.NTSB ANC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Anchorage, AKThe failure of an exhaust valve. The lack of suitable terrain for a forced landing was a factor.NTSB ANC94FA036Accident · No injuriesField investigationFinal reportLockheed L-1011 · Fairbanks, AKFailure of the sixth stage disc on the intermediate compressor stage 6/7TH rotor shaft assembly in the number three engine, due to corrosion pitting and fatigue cracking of the failed disc. A factor related to the accident was: failure of the airline company…NTSB ANC93IA176Incident · No injuriesIncident investigationFinal reportSikorsky C54A · Anita Bay, AKThe separation of the turbine blade from the power turbine disc.NTSB ANC93LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Skagway, AKA total loss of engine power as a result of a fatigue failure of the #2 connecting rod. A factor which contributed to the accident was the lack of suitable terrain for the emergency landing.