NTSB investigations, NC
27 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 2 |
| 1988 | 2 |
| 1989 | 3 |
| 1992 | 3 |
| 1993 | 2 |
| 1995 | 1 |
| 1997 | 3 |
| 1998 | 3 |
| 2001 | 1 |
| 2002 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 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\" = 'NC' 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" = 'NC' 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 MIA07CA141Accident · No injuriesData collectionFinal reportCessna 172 · Mooresville, NCThe inadequate preflight inspection of the airplane by the pilot-in-command for his failure to remove all water contamination from the fuel system.NTSB ATL06CA015Accident · Minor injuriesData collectionFinal reportPiper PA-32-260 · Bryson City, NCThe loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat.NTSB ATL04CA115Accident · Minor injuriesData collectionFinal reportLoehle Ent. 2/3 Earlybird Jenny · Grantham, NCThe loss of engine power for undetermined reasons.NTSB MIA03LA020Accident · No injuriesLimited investigationFinal reportCessna 150L · Powells Point, NCa loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing.NTSB ATL02LA114Accident · No injuriesLimited investigationFinal reportBeech 23 · Greensboro, NCThe loss of engine power for undetermined reasons, A factor was the pilot's intentional ground loop during a forced landing.NTSB MIA01LA185Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Mooresville, NCthe pilot's improper fuel consumption calculations, inadequate preflight planning, and failure to refuel the airplane before takeoff, which resulted in a loss of engine power due to fuel exhaustion, and a forced landing in trees.NTSB ATL99LA012Accident · No injuriesLimited investigationFinal reportAeroSport WS-15-2 · Parkton, NCThe collapse of the carburetor heat box hose which starved the carburetor of air resulting in a partial loss of power, forced landing and nose over. Factors were the weeds and stocky stubble in the forced landing zone.NTSB MIA98LA249Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Burlington, NCThe pilot's failure to abort the takeoff after recognizing that the airplane was slow to accelerate during the takeoff roll, and his not obtaining/maintaining clearance with the wire during the forced landing. Contributing factors were carburetor icing…NTSB MIA98FA176Accident · 2 fatalField investigationFinal reportMooney M-20E · Winston-Salem, NCThe pilot's improper decision to conduct a maintenance test flight with a known unairworthy mechanical condition (unserviceable servo fuel injector), resulting in a partial loss of engine power on climb out, subsequent forced landing, and in-flight collision…NTSB ATL98LA026Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Jacksonville, NCthe pilot's improper preflight inspection by failing to ensure the fuel selector was properly positioned, which led to fuel starvation, loss of engine power, and a forced landing on rough/uneven terrain. The lack of suitable terrain for a forced landing was a…NTSB ATL97LA138Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fairview, NCfuel contamination, and the pilot's inadequate preflight of the airplane. A factor relating to the accident was: an inability to attain a proper touchdown point, which led to the runway overrun.NTSB ATL97LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sophia, NCimproper maintenance performed by an unknown person, which resulted in the reduction of airflow through the engine induction system and subsequent loss of engine power. A factor related to the accident was: failure of the pilot to attain a proper touchdown…NTSB ATL95LA081Accident · Serious injuriesLimited investigationFinal reportEccker, Donald E. Rans S-10 · Wilson, NCThe pilot's failure to maintain control of the airplane during the touchdown phase of the emergency landing to the runway. The lack of a carburetor heat system and the carburetor icing weather conditions were factors.NTSB ATL93LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Statesville, NCThe improper use of carburetor heat by the pilot. A factor in the accident was the carburetor icing conditions.NTSB ATL93LA102Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Greensboro, NCThe pilot's improper use of carburetor heat during the flight. Factors were the carburetor icing conditions at the time of the accident, and trees at the forced landing siteNTSB ATL92FA111Accident · 1 fatalField investigationFinal reportCessna 152 · Lake Waccamaw, NCThe failure of the pilot to follow proper procedures while operating the aircraft in weather conditions favorable to carburetor icing. A factor in the accident was the weather condition, which was favorable for the formation of carburetor ice.NTSB ATL92LA098Accident · Minor injuriesLimited investigationFinal reportAvid Flyer Heavy Hauler · Wendell, NCThe improper installation of the forward spark plug by the owner/pilot, which resulted in a loss of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB ATL92LA092Accident · No injuriesLimited investigationFinal reportCessna 172E · Concord, NCThe loss of engine power because of the formation of carburetor ice.NTSB ATL89LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rowland, NCThe pilot's failure to recognize and prevent carburetor icing prior to take off.NTSB ATL89LA121Accident · Minor injuriesLimited investigationFinal reportAero Commander 685 · Southern Pines, NCThe pilot's improper use of the mixture controls which resulted in engine roughness and the failure to properly execute the emergency procedure for a rough engine by placing the fuel boost pump switch in the low position.NTSB ATL89LA069Accident · No injuriesLimited investigationFinal reportBoeing E75 · Salisbury, NCImproper use of carburetor heat by the pilot, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions and obstruction(s)/utility pole near the departure end of the runway.NTSB ATL89LA017Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Advance, NCDuring takeoff climb eng quit then re-started. PIC turned to the north & engine quit again. PIC stalled acft & crashed into wheat field. Acft had STC for auto gas. Fuel in acft had water & rust contaminants. Fuel lines had dried. Carb had composite float. The…NTSB ATL88LA206Accident · No injuriesLimited investigationFinal reportCessna 172M · Spring Creek, NCThe plt reported that the engine began to run rough & lose power as the airplane climbed through 9,000 ft MSL. She then switched fuel tanks and moved the mixture to full rich, but the engine continued to lose power. Carb heat was not used at any time. A…NTSB ATL86LA250Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Elkin, NCPlt said he had been performing take offs and landings. Engine lost RPM at about 50 AGL. An attempt was made to land on the sod rwy which resulted in a hard landing and collapse of the right main landing gear. Plt said he suspected carburetor icing. Icing…NTSB ATL86LA050Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Charlotte, NCPlt reported loss of power on the right eng at about 20 ft alt on takeoff. The acft veered right, the plt aborted the takeoff and touched down on the right side of rwy. The acft struck a mound of dirt and the ldg gear collapsed. The takeoff was initiated from…NTSB ATL84FA126Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Fletcher, NCDuring takeoff the left eng lost power shortly after the landing gear was retracted. The plt stated that he felt the loss of power at about the same time that he turned off the landing lights. With the left eng manifold pressure gauge reading 25 inches hg,…NTSB ATL82FLJ04Accident · 2 fatalFinal reportPorterfield CP-65 · Jacksonville, NCWitnesses heard the eng sputter after takeoff as the acft was in a steep climb. The acft was then observed to turn sharply left, enter a nose down attitude & crash. About 1/2 teaspoon of rusty water was found in the main fuel strainer & the fuel screen…