NTSB investigations, LA
30 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 1 |
| 1989 | 2 |
| 1990 | 4 |
| 1992 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 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\" = 'LA' 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" = 'LA' 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 DFW07CA037Accident · No injuriesData collectionFinal reportHughes 269B · Houma, LAA partial loss of engine power as a result of a cracked engine cylinder and broken spark plug which resulted in a hard landing. A factor was that it was not possible to attain proper rotor RPM.NTSB DFW05CA186Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164A · Tallulah, LAThe partial loss of engine power as result of the fracture of the number five-cylinder exhaust valve rocker arm mounting boss. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA176Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Jonesville, LAThe pilot's failure to maintain clearance with the power lines.NTSB FTW01LA193Accident · No injuriesLimited investigationFinal reportGrumman G164B · Rayville, LAthe partial failure of the magneto drive coupling while maneuvering, which resulted in a loss of engine power and a forced landing. A contributing factor to the accident was the lack of suitable terrain for the forced landing.NTSB FTW00LA239Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAthe failure of the supercharger during takeoff. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW99FA262Accident · 4 fatalField investigationFinal reportBeech A36TC · Franklinton, LAThe pilot's inadvertent stall while attempting to clear trees during a go-around. Factors were the pilot's misjudgment of the airplane's distance and speed during the precautionary landing and the partial loss of engine power due to a perforated piston.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 FTW92LA116Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Welsh, LAPartial power loss due to the cracked engine cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW91FA025Accident · 1 fatalField investigationFinal reportPiper PA28-181 · Olla, LAThe collapsed carburetor float and restricted movement of the fuel metering needle. Factors were the darknight, the unsuitable terrain, and the operator's maintenance personnel failure to inspect (repair) the engine.NTSB FTW90DRD07Accident · No injuriesFinal reportGrumman G-164A · Ville Platte, LAPartial loss of engine power due to a cracked number four cylinder intake rocker box housing. The lack of a suitable forced landing site was a related factor.NTSB FTW90DRD05Accident · No injuriesFinal reportSchweizer G-164B · Reeves, LALoss of engine power due to a frozen rocker arm.NTSB FTW90LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rayne, LAFailure of the #3 exhaust valve, which necessitated a forced landing on unsuitable terrain.NTSB FTW89DRD09Accident · No injuriesFinal reportSchweizer G-164A · Bunkie, LAThe loss of the number five cylinder in flight, resulting in a loss of engine RPM. The pilot misjudged the landing flare height due to obscured vision from fire and smoke and the airplane stalled and impacted the ground nose first.NTSB FTW89LA114Accident · No injuriesLimited investigationFinal reportCessna 150J · Minden, LAThe loss of engine power due to improper maintenance performed during an annual inspection 1.6 flying hours prior to the accident which resulted in the mixture control becoming disconnected.NTSB FTW88DRD01Accident · No injuriesFinal reportGrumman G-164A · Port Allen, LAThe pilot experienced a partial loss of power during pull-up from a swath run. He attempted to return to the field he was working in order to make an emergency landing but was unable to due to inadequate engine power. He landed in high vegetation and flipped…NTSB FTW86LRD16Accident · No injuriesFinal reportGrumman G-164B · Abbeville, LAThe pilot stated he made a successful forced landing, due to loss of power, and then had to flip the aircraft to prevent colliding with a lateral (above ground irrigation system) with a water depth of about four feet. Subsequent engine examination revealed…NTSB FTW86LRD12Accident · No injuriesFinal reportGrumman G-164A · Branch, LAShortly after takeoff, a partial power loss occurred & the plt made a forced landing in a soft plowed field, where the acft nosed over onto its back. The plt rprtd the loss of power was due to failure of the eng blower.NTSB FTW86FA079Accident · 6 fatalField investigationFinal reportCessna 411A · Bossier City, LAThe pilot reportedly did an unusual amount of engine run-up before pulling onto the runway. He then performed another run-up before departing. This is evidence that he was aware of a problem with his aircraft. The engine(s) were popping and puffing black…NTSB FTW85FA310Accident · 1 fatalField investigationFinal reportBell UH-1B · Saint James, LAAcft was at a 150' hover preparing to pick up a log when it experienced a power loss. Witnesses stated that they heard a loud 'bang' and the pilot radioed 'get out of the way'. Acft autorotated thru 60' to 80' trees with very low rotor RPM and impacted with…NTSB FTW85LA215Accident · Serious injuriesLimited investigationFinal reportCessna 210E · Natchitoches, LAThe pilot experienced partial power loss due to ingestion of the alternate air door shaft needle bearing rollers into the engine, and cross firing of the right magneto. He reportedly closed the throttle and made a gear up forced landing. The aircraft slid…NTSB FTW85FA188Accident · Serious injuriesField investigationFinal reportBell UH-1B · Boutte, LAThe plt had stabilized acft in a 125' hover, prior to picking up a load, when the eng spooled down and acft entered talltrees with low rotor RPM and pitched nose down as it descended thru the trees. Ground witnesses heard 2 loud 'bangs' prior to the acft…NTSB FTW84LA282Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Houma, LAThe helicopter autorotated into trees and marsh land after a partial loss of power. The acft was on a pipeline patrol atlow alt at the time of the power loss. Examination of the engine after the accident revealed that the fuel control governor spring, p/n…NTSB FTW84LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe plt reported after the accident that he was dispensing fertilizer and had just flown through a heavy rain shower when the engine began to lose power. A forced landing was made in a flooded rice field and the acft nosed over. The pilot stated that he was…NTSB FTW84LA185Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Eunice, LAThe plt reported that the engine lost power on takeoff and return to the rwy was not possible, so he landed on the edge of a pond. A post accident investigaiton revealed a crack in the #7 cyl head between the spark plug holes. The engine had just gotten a…NTSB FTW84LA179Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Lake Charles, LAThe acft hit a tree and a ditch during a forced landing on a road after the engine lost power. Examination of the engineafter the accident revealed that the throttle rod had disconnected from the throttle control arm at the bolt hole. The hole had worn…NTSB FTW83LA297Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Lafayette, LAThe helicopter made a hard precautionary landing after the plt noted the rotor RPM and N2 would bleed off when collective pitch was increased to 80 percent torque. The plt returned to the arpt and elected to autorotate instead of landing with power available.…NTSB FTW83FA252Accident · 1 fatalField investigationFinal reportPiper PA-60 · New Orleans, LAWitnesses reported that when the acft was stabilized on final apch, it pitched up slightly & yawed, then rolled left to an inverted attitude & crashed in a canal. Several witnesses stated that the left prop was windmilling. One stated the left prop had…NTSB FTW83LA062Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ruston, LAOn takeoff the pilot heard a loud bang sound then lost engine power. The pilot made a 180 degree descending turn back toward the airport. At the edge of the airport the pilot made a hard touchdown on all three gear assemblies. Investigation revealed the…NTSB FTW82DA178Accident · No injuriesFinal reportBell 206L-1 · Cameron, LAWhile enroute to refuel the pilot experienced a loss of power and elected to autorotate to the ground. The aircraft rocked forward then back on landing and the main rotor severed the tailboom. Investigation revealed both fuel flow switches were stuck in the…NTSB FTW82DA169Accident · No injuriesFinal reportGrumman G164A · Welsh, LADuring the initial takeoff with a load of fertilizer the engine lost power and the load was dumped. A forced landing wasmade in a plowed, wet field and the aircraft nosed over. Investigation revealed the cylinder head failed.