NTSB investigations, AL
16 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1995 | 1 |
| 1998 | 1 |
| 1999 | 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\" = 'AL' 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\" = 354)
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" = 'AL' 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" = 354) 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 ATL04LA105Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Elberta, ALThe loss of engine power due to a foreign substance blockage of the fuel line which resulted in fuel starvation, and the pilot's failure to maintain terrain clearance during an aborted landing.NTSB ATL03LA113Accident · 1 fatalLimited investigationFinal reportAero Vodochody Aero Works L39C · Gadsden, ALThe loss of engine power during takeoff due to foreign object damage, which resulted in an in-flight collision with terrain during forced landing. Factors were the pilot's inadequate preflight inspection of the airplane, his failure to secure the…NTSB MIA00LA044Accident · Serious injuriesLimited investigationFinal reportAmerican AA-5 · St. Elmo, ALThe failure of the pilot to maintain airspeed resulting in the in-flight loss of control while maneuvering for a forced landing in a field after the loss of engine power. Contributing factors were the loss of engine power due to water-contaminated fuel.NTSB MIA98FA060Accident · 1 fatalField investigationFinal reportFairchild 24G · Andalusia, ALA loss of engine power while in cruise flight caused by a contaminated fuel supply and the subsequent inflight collision with trees and unsuitable terrain during the emergency descent and landing.NTSB ATL95LA161Accident · Serious injuriesLimited investigationFinal reportRonsrans R 12 · Clanton, ALThe pilot's failure to maintain proper flying speed, and the improper mixture of the fuel.NTSB ATL91LA143Accident · No injuriesLimited investigationFinal reportHinton Kitfox · Killen, ALWeather conditions conducive to carburetor icing. A factor was the lack of a carburetor heat system on the engine.NTSB ATL91FA138Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Mobile, ALThe failure of the pilot to maintain airspeed and his subsequent inadvertent stall during his attempt to return to the departure runway. A factor was the loss of engine power for undetermined reasons.NTSB ATL90FA055Accident · 1 fatalField investigationFinal reportAmerican AA-1 · Cherokee, ALCarburetor ice due to the pilot's improper use of carburetor heat, and failure of the pilot to maintain control of the airplane after the engine lost power. The weather (carburetor icing) condition was a related factor.NTSB ATL90LA030Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B1 · Ewell, ALThe loss of engine power, for undetermined reasons, at low altitude during a practice autorotation. Contributing to the accident was the instructor's failure to properly plan the demonstrated autorotation so as to preclude an accident, in the event that power…NTSB ATL88LA012Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Scyrene, ALThe engine lost pwr during a low-altitude powerline patrol. The airplane nosed over during the subsequent forced ldg. Post-crash examination of the acft by an FAA inspector revealed that the fuel tank vent system was obstructed with mud-dauber nests in…NTSB ATL87LA068Accident · 1 fatalLimited investigationFinal reportCessna 150M · Pinson, ALDuring intial climb after takeoff the eng quit and restarted more than once. The acft was turned back toward the departure rwy. During the turn, the wing struck a tree, control was lost, and the acft collided with the ground. Examination of the eng revealed…NTSB ATL86LA260Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Montgomery, ALDuring initial climb phase of an experimental flt from mgm, AL, the plt rpted that the left engine had failed and an attempt was made to feather the prop. The plt radioed dannelly tower that the acft was returning to the arpt. Then the plt rpted that the…NTSB ATL86LA168Accident · No injuriesLimited investigationFinal reportAnderson Tierra II 1984 · Smith Station, ALThe acft's engine lost pwr shortly after t/o and a forced ldg was made in some saplings. The plt reported that he neglected to use the electric fuel boost pump during the t/o and subsequent pwr loss. He had previously installed the pump on the home-built acft…NTSB ATL85FKG01Accident · Serious injuriesFinal reportPiper PA-28-140 · Huntsville, ALAccording to the pax very shortly after takeoff the acft 'stall light' illuminated as the acft flew over trees aft the end of the rwy. One pax reported that the acft climbed slightly before it dropped to the ground left wing and nose first. Exam of the eng…NTSB ATL84LA007Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Mccullough, ALThe acft crashed in a cotton field after maneuvering at low alt to check the crop. The pilot said he was at an alt of 4 or 5 ft and forward flt was below transitional lift speed. The rotor RPM began to reduce and also there was a drop in engine RPM. The pilot…NTSB ATL83LA309Accident · No injuriesLimited investigationFinal reportCessna 172N · Birmingham, ALThe instructor (CFI) reported the eng began missing when power was applied after practicing stalls. A decision was made to return to the arpt. Carburetor heat was applied & the throttle was retarded to descend. The mixture was in full rich. After a couple of…