NTSB investigations, AL
59 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases, newest first
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\" = 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" = '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" = 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 ATL84FKG08Accident · No injuriesFinal reportCessna 177RG · Pell City, ALDuring the takeoff sequence, the alternate air door hinge failed, allowing the door to separate and progressively block the induction air system to the point that insufficient power was available to sustain further flight. A forced landing was effected in a…NTSB ATL84FA100Accident · 1 fatalField investigationFinal reportBell 47GL · Cullman, ALThe plt had just completed an eng overhaul & was test flying the helicopter. While maneuvering at aprx 100 ft AGL, the eng lost power & the plt initiated an autorotation. During the landing, the helicopter impacted hard on rising terrain, rolled onto its side…NTSB ATL83LA341Accident · No injuriesLimited investigationFinal reportCessna A188B · Samson, ALThe acft collided with a dirt bank during a forced landing after an inflt power loss. The pilot was enroute to a field at about 500 ft AGL when the power loss occurred. The pilot did not jettison his load of chemicals. He landed on wet grass and was unable to…NTSB ATL83LA170Accident · No injuriesLimited investigationFinal reportCessna A-188B · New Hope, ALThe acft struck powerlines and crashed during an emergency landing after a loss of power while spraying on an aerial application mission. The plt stated that while spraying he noticed oil beginning to cover the windshield. He had begun aclimb and dumped the…NTSB ATL83LA168Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · New Hope, ALThe acft collided with trees during a forced landing following an engine failure. The pilot stated that during a pull-upafter spraying a field the engine made a loud bang and smoke and oil began to pour out of the engine. Then the engine froze and the pilot…NTSB ATL83FKJ01Accident · 1 fatalFinal reportCessna 172N · Clanton, ALThe acft was observed in a high speed glide to touch down briefly in a pasture at the top of a knoll. It then dropped below the rise & crashed in a wooded area adjacent to the pasture. Examination of the eng showed a crack extending from the top forward…NTSB ATL82DA275Accident · Minor injuriesFinal reportCessna 172F · Millry, ALThe pilot experienced a partial loss of power during a ferry flight and was forced to make an emergency landing in a field. He stated that he noted 4 vibrations followed by a missing in the engine. The RPM dropped to 1200 and he could not maintain altitude.…NTSB ATL82DA226Accident · No injuriesFinal reportHughes 269A · Wetumpka, ALThe pilot reported that at the end of a spray run, the engine lost power. He stated that the engine RPM dropped to zero, the airspeed was zero, and he established an autorotation. According to the pilot, the helicopter touched down on rough hilly terrain,…NTSB ATL82DA105Accident · Minor injuriesFinal reportAyres S2R-600 · Evergreen, ALThe pilot stated that about 5 minutes after takeoff the engine skipped once, popped, then quit completely with no other warning. The aircraft was over a wooded area and was forced to land in the trees. It was determined that the aircraft was approximately 740…