NTSB investigations, MD
17 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 3 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2001 | 2 |
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\" = 'MD' 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" = 'MD' 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 IAD01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Odenton, MDImproper maintenance inspections, which resulted in a blocked carburetor.NTSB IAD01LA083Accident · No injuriesLimited investigationFinal reportCessna 150L · Lusby, MDThe student pilot's improper use of carburetor heat.NTSB NYC01LA060Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Mitchellville, MDA loss of engine power for undetermined reasons.NTSB IAD97LA086Accident · Minor injuriesLimited investigationFinal reportLuscombe LL-8-A · Annapolis, MDthe pilot's failure to use carburetor heat, which resulted in accumulation of carburetor ice and subsequent loss of engine power. Related factors were: carburetor icing conditions, and trees in the emergency landing area.NTSB BFO94FA043Accident · Serious injuriesField investigationFinal reportBeech C35 · Rockville, MDThe pilot's inadequate aircraft preflight inspection which resulted in a loss of engine power due to fuel contamination.NTSB BFO92LA087Accident · No injuriesLimited investigationFinal reportPiper J3C · Frederick, MDThe pilot's improper use of carburetor heat resulting in the formation of carburetor ice. Carburetor icing weather conditions was a factor.NTSB BFO91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Croom, MDThe pilot's failure to assure an adequate fuel supply was on board to complete the flight which resulted in fuel exhaustion.NTSB BFO89LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cumberland, MDThe pilot stated that shortly after takeoff at an altitude of aprx 150 ft AGL, the engine sputtered and lost power. According to the police report, the pilot attempted to return to the airport. During the turn the wingtip contacted the ground and the airplane…NTSB BFO88FA063Accident · No injuriesField investigationFinal reportPiper PA-23 · Friendly, MDShortly after takeoff at an altitude of 200 ft AGL, a power loss was experienced on the left engine. According to the plt, when the throttle was retarded to verify the engine failure, the engine seemed to 'come back to life'. The throttle was advanced and…NTSB BFO88LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Annapolis, MDThe plt said he did a preflight inspection of the acft which included a check for water in the fuel. Tanks were partially full- 17 gals in each one. A pre-takeoff eng runup was normal. During the initial takeoff climb the eng had a partial power loss. After…NTSB BFO86FA029Accident · Minor injuriesField investigationFinal reportCessna 150L · Upper Marlboro, MDThe acft made a forced landing after the eng began to overheat during cruise flt about 20 minutes after departure. The plt stated that as soon as he smelled the oil heating up he knew what the problem was. He had not removed the foam plugs from the air…NTSB BFO86LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Elkton, MDThe acft experienced a loss of pwr during cruise. The student plt reported that carb heat was applied after the initial pwr loss without any change in RPM. He subsequently applied full throttle, but the acft was unable to maintain altitude and a forced ldg…NTSB BFO85FA077Accident · Serious injuriesField investigationFinal reportCessna 150E · Clinton, MDPlt stated that on initial climb from a normal takeoff, a partial engine pwr loss was experienced. Control of the airplane was lost while maneuvering for a suitable forced landing area. A flight instructor that witnessed the takeoff stated that it appeared to…NTSB NYC84FIA03Accident · Minor injuriesFinal reportBeech 35 · Park Hall, MDThe plt noted that the engine ran rough at low RPM but smoothed out at higher pwr settings. Despite that finding the pltelected to takeoff but aborted as he realized that he would not be able to get airborne before reaching the end of the rwy. After taxiing…NTSB ATL84FIA01Accident · No injuriesFinal reportCessna 150K · Newburg, MDThe plt reported that during takeoff at aprx 200 ft AGL, the eng began to sputter & run rough. He elected to make a 180 deg turn in an attempt to reach a clear area. However, the acft struck a tree & impacted in a wooded area. Reportedly, the acft had been…NTSB ATL83FA045Accident · Serious injuriesField investigationFinal reportCessna 150M · Edgewater, MDApproximately 45 min after takeoff, the eng started to run rough. The plt headed toward the nearest arpt with the eng still running rough. The plt entered downwind & proceeded to follow a normal landing pattern. As he turned final, the eng quit completely.…NTSB ATL82DA178Accident · No injuriesFinal reportBellanca 7ECA · Ft. Meade, MDThe pilot reported that the carburetor heat operated during an engine run-up before takeoff, and that he used the carburetor heat during each landing. During a touch-and-go, he lifted off at 65 KTS, but the plane settled and would not climb out of ground…