NTSB investigations, LA
22 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1983 | 4 |
|---|---|
| 1984 | 2 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1990 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2004 | 2 |
| 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\" = 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" = '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" = 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 DFW06CA077Accident · No injuriesData collectionFinal reportCessna 182C · Gilliam, LAThe loss of engine power due to carburetor ice. Contributing factors were the pilot's failure to use carburetor heat and the lack of suitable terrain for the forced landing.NTSB DFW05CA149Accident · No injuriesData collectionFinal reportBell 206L-1 · Moulton Cove, LAThe loss of engine power due to foreign object ingestion into the compressor. A contributing factor was the lack of suitable terrain (swampy) for the forced landing.NTSB DFW05CA044Accident · No injuriesData collectionFinal reportBell B206L-1 · Patterson, LAThe loss of engine power due to fuel starvation resulting from the pilot's failure to activate the fuel boost pumps prior to takeoff. A contributing factor was that the helicopter was at an airspeed and altiutude combination (below height/velocity curve)…NTSB FTW04LA229Accident · No injuriesLimited investigationFinal reportCessna 175 · De Ridder, LAThe partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02FA037Accident · 1 fatalField investigationFinal reportGrumman American AA-1B · Patterson, LAThe pilot's mismanagement of fuel with the positioning of the fuel selector in the off position and his failure to maintain airspeed resulting in fuel starvation, and the airplane entering into a stall.NTSB FTW97LA270Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Amelia, LApartial loss of engine power due to frog(s) being ingested into the engine. Factors relating to the accident were: the lack of altitude and lack of suitable terrain for a forced landing.NTSB FTW97LA016Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Venice, LAa loss of engine power due to frogs being ingested into the engine as a result of the pilots failure to perform a thorough preflight, and the pilot's improper touchdown technique.NTSB FTW95FA186Accident · 1 fatalField investigationFinal reportBell 206L-3 · Venice, LALoss of engine power due to ingestion of exhaust fumes from an oil platform flare boom.NTSB FTW95FA016Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Eunice, LAThe pilot's failure to properly use carburetor heat, the formation of carburetor ice, and failure of the pilot to maintain rotor RPM after loss of engine power, which resulted in a loss of control and collision with terrain. A factor related to the accident…NTSB FTW90DRD12Accident · Minor injuriesFinal reportGrumman G-164A · Bastrop, LAThe pilot's improper engine procedures during ground operations and prior to takeoff which resulted in fouled spark plugs.NTSB FTW88LA130Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Slidell, LAThe student pilot landed on the private strip to pick up a passenger. The pilot reported that after takeoff he smelled smoke and almost immediately, the engine started cutting out. The airplane impacted the tops of tall trees, thena fence, and then impacted…NTSB FTW88DRD11Accident · Minor injuriesFinal reportSchweizer G-164B · Cheneyville, LAThe ag airplane was returning after spraying chemical when the engine started to lose power. During the forced landing on a highway the left wing struck a road sign. No mechanical reason for the engine power loss was found. The acft had an annual inspection…NTSB DCA87MA033Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Kenner, LAThe acft overran the dept end of the rwy and came to rest on a hiway barrier after an aborted takeoff following engine torque oscillations. The capt tried reducing the power levers as he had been taught to 'get off' the ttl since he thought the ttl was…NTSB FTW87FA100Accident · No injuriesField investigationFinal reportBeech D55 · Cameron, LAThe left engine lost power at rotation but, due to the short runway (2500-SOD), the pilot elected to continue the takeoff. He switched the left fuel selector, placed the boost pump switch in the 'high' position and retracted the landing gear and flaps but did…NTSB FTW86FRD24Accident · No injuriesFinal reportTexas Helicopter OH-13E/M74 · Port Allen, LAThe helicopter experienced partial power loss and descended to ground. It spray booms became entangled in the soy beans. The helicopter started to nose over, then rolled onto its right side and came to rest. Reason for the partial power loss is undetermined.NTSB FTW86LA095Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Orange Grove, LADuring a part 135 check ride, the check plt had the plt execute a pwr off landing from an alt of 150 ft AGL. The plt reacted to the pwr loss by attempting a left turn to land. The acft then stalled and impacted the ground after the failure maintain airspeed.NTSB FTW85LA091Accident · No injuriesLimited investigationFinal reportCessna 210L · Monroe, LAThe acft suffered a collapsed nose gear after losing and regaining power during an ILS approach and finally completing an emergency landing two miles from the rwy of intended landing. There were no injuries and no fire. Examination of the acft in the field…NTSB FTW85LA042Accident · Minor injuriesLimited investigationFinal reportCessna 441 · Grand Chenier, LAThe pilot told the cameron parrish sheriff that he was attempting to land the aircraft at a small agricultural landing strip after one of the two engines quit due to fuel starvation. The pilot stated that there was nothing wrong with the aircraft except that…NTSB FTW83LA345Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Houma, LAThe acft had previously been submerged in water. After it was salvaged & repaired, a ferry permit was obtained to fly it to amarillo, TX. According to a witness, the eng began running rough after the 1st 50 ft of the ground roll during takeoff. However. The…NTSB FTW83LA277Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAThe acft collided with a dirt levee during takeoff after an engine malfunction. According to the plt he experienced a power failure at liftoff. He dumped his spray load and applied brakes. The engine regained partial power and failed again. At about 60 mph…NTSB FTW83FA121Accident · Minor injuriesField investigationFinal reportCessna P210 · Alexandria, LAThe acft made excessively steep turns at low altitude and the engine lost power. During the forced landing that followedthe acft struck a tree and rolled inverted. It struck the ground in a near vertical nose down attitude. From the amount of fuel aboard at…NTSB FTW83LA089Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Loreauville, LAReportedly, the acft was preflighted and all three water traps (sumps) were drained until only fuel flowed. During takeoff, the engine began losing power at aprx 400 ft AGL. An emergency landing was made in a cane field. During touchdown, the acft hit rows in…