NTSB investigations, PA
20 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1985 | 2 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 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\" = 'PA' 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" = 'PA' 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 NYC06LA112Accident · 2 fatalLimited investigationFinal reportBulmer Lancair IV-P · Somerset, PAThe pilot's failure to maintain sufficient airspeed after takeoff to preclude a stall, which resulted in a loss of control and an inadvertent stall. Factors associated with the accident are the inadvertent stall, the loss of engine power due to the pilot's…NTSB NYC04LA187Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Phillipsburg, PAA loss of partial engine power for undetermined reasons.NTSB NYC04FA077Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Corry, PAThe loss of partial engine power for undetermined reasons, and the pilot's lost of control after performing an evasive maneuver to avoid trees during a forced landing at night. Factors related to the accident were a rough running engine and the pilot's…NTSB NYC03LA115Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman D75-N1 · Avis, PAA loss of engine power due to carburetor ice. A factor in this accident were weather conditions favorable to carburetor ice.NTSB IAD01LA033Accident · No injuriesLimited investigationFinal reportMooney M20C · Peckville, PAloss of engine power for undetermined reasons.NTSB NYC00LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · E. Stroudsburg, PAThe pilot's decision to takeoff with only partial engine power available.NTSB IAD00LA005Accident · No injuriesLimited investigationFinal reportAnkenbruck SEA Hawk · Somerset, PAThe pilot's improper preflight which resulted in a loss of power due to contaminated fuel, and the pilot's failure to maintain aircraft control after the loss of power. A factor in the accident was fuel contamination.NTSB NYC98LA053Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Riverside, PAthe pilot's improper response to the low rotor RPM warning. Factors in the accident were the pilot's failure to turn for the forced landing area and the carburetor icing conditions.NTSB NYC95LA077Accident · No injuriesLimited investigationFinal reportCessna 150J · Slatington, PAThe pilot's improper use of carburetor heat which resulted in carburetor icing and a subsequent loss of engine power. A factor is carburetor icing conditions.NTSB NYC94LA125Accident · No injuriesLimited investigationFinal reportCessna 150J · Coatsville, PAThe pilot's inadequate use of carburetor hear. A factor was carburetor icing conditions and soft terrain.NTSB BFO92LA140Accident · No injuriesLimited investigationFinal reportBeech 19 · Revere, PAThe loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.NTSB NYC92LA109Accident · No injuriesLimited investigationFinal reportCessna 150L · Gettysburg, PAThe student pilot's delayed action in applying carburetor heat during cruise, which resulted in a loss of engine power due to carburetor ice. Factors in this accident were: weather conditions conducive for carburetor icing, the pilot's lack of total flying…NTSB NYC91LA222Accident · No injuriesLimited investigationFinal reportCessna T-210-M · Clearfield, PAVapor lock of the fuel system resulting in fuel starvation. A factor related to the accident was the failure of the owner to comply with a service letter calling for insulated fuel lines forward of the fire wall.NTSB NYC91LA090Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Phillipsburg, PACarburetor ice and the pilot's improper use of carburetor heat. Factors related to the accident were: the carburetor icing (weather) conditions and the lack of suitable terrain for a forced landing.NTSB NYC91DHA01Accident · 1 fatalFinal reportJames Cote Kolb Twinstar MK II · Gilbertsville, PAThe failure of the pilot to maintain control of the aircraft after an interuption of power.NTSB NYC90LA071Accident · No injuriesLimited investigationFinal reportCessna 177RG · Harford, PAA loss of braking action which allowed the aircraft to run into trees after the pilot made a precautionary landing due to a rough running engine of undetermined cause.NTSB NYC87DGM02Accident · No injuriesFinal reportNoonan VARI-EZE · Ebensburg, PAThe vari-eze was part of a three ship flyby at an airshow. The accident aircraft was observed to break formation and turn downwind for a landing. A witness reported the engine sputtering. The aircraft landed in a open field next to the runway. Examination…NTSB NYC87DGM01Accident · Serious injuriesFinal reportMooney M20F · Eighty Four, PAThe pilot reported experiencing a rise in the acft's EGT and a loss of power during cruise flt. A forced landing was made during which the acft contacted trees. Examination of the fuel system showed that both the main fuel screen and the micro screen in the…NTSB NYC85FA222Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Carlisle, PADuring the second takeoff attempt from a pvt grass strip witnesses heard the eng sputter then quit soon after liftoff. The acft then descended to ground impact and burned. The acft had not been flown adn was kept out of doors for several months while the…NTSB NYC85FGM03Accident · Minor injuriesFinal reportIstvanick Zipppy Sport · Connellsville, PAThe acft contacted trees following a loss of pwr shortly after takeoff. Plt stated he performed 3 high speed taxi runs during which the acft and eng operated normally. Witnesses stated the acft became airborne on the 4th taxi run, climbed to aprx 75 ft AGL…