NTSB investigations, VA
15 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 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\" = 'VA' 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" = 'VA' 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 DFW08CA006Accident · No injuriesData collectionFinal reportVans RV6 · Halifax, VAThe pilot's inadvertent stall during a forced landing. A contributing factor was the pilot's failure to place the electronic prop controller in the manual mode prior to aborting the landing which resulted in a loss of engine power.NTSB IAD98LA077Accident · Minor injuriesLimited investigationFinal reportBennett Piel Emeraude · Hillsville, VAA blocked fuel strainer due to an inadequate maintenance inspection by the previous owner, which resulted in fuel starvation.NTSB BFO96LA021Accident · Minor injuriesLimited investigationFinal reportBeech E55 · Manassas, VAfailure of the pilot to maintain control of the airplane, when the left engine lost power shortly after liftoff. Related factors were the pilot's failure to follow the checklist procedure, and his failure to ensure that the fuel selector was in the proper…NTSB NYC94FA064Accident · 1 fatalField investigationFinal reportSwearingen SA-26AT · Winchester, VAThe pilot's decision to operate the airplane with known deficiencies in the fuel quantity measuring system which resulted in a power loss due to fuel starvation, followed by improper emergency procedures which resulted in a loss of control inflight and…NTSB NYC94LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Christianburg, VAThe pilot's improper use of carburetor heat which prevented the accumulation of carburetor ice and resulted in the loss of engine power. A factor was unsuitable terrain.NTSB BFO91FA072Accident · 1 fatalField investigationFinal reportCessna 210N · Petersburg, VAThe pilot's inadequate pre-takeoff check and his failure to abort the takeoff. Inadequate maintenance of the engine was a factor.NTSB BFO89LA056Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Bealeton, VAWater in the fuel, which resulted in a momentary loss of power during an inverted low pass, and the pilot's failure to plan the maneuver to allow for appropriate remedial action.NTSB BFO89LA039Accident · Minor injuriesLimited investigationFinal reportAircoupe Alon A2A · Sutherland, VALow output of the magnetos which resulted in the loss of full power during the attempted recovery from a simulated forced landing. The pilot ignored indications of an engine problem during start when the engine was hard to start.NTSB BFO87LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Tappahannock, VAThe acft was at 1500 MSL when a 300 RPM loss of power occurred. The plt sighted a private landing strip and he decided to make a precautionary landing on it. During the landing roll on the 62 ft wide grass strip the l wing struck corn stalks in an adjacent…NTSB BFO86FA044Accident · 1 fatalField investigationFinal reportCessna 177B · Springfield, VAAccording to the plt, the eng bgn running rough drg flt, then clrd & ran smoothly again. He rprtd he elected to abort the flt & made a turn, then svrl min later, the eng lost pwr. Drg an emerg lndg in a parking lot, the l main gear hit anauto & fatally…NTSB BFO85LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Lynchburg, VAAs the gear was retracting after takeoff, the acft began to lose power. The plt could detect no yaw to either side. When the acft was about 50 feet off the ground, the twr informed the plt that vapor or smoke was trailing from the left eng. The plt…NTSB ATL85FA054Accident · Serious injuriesField investigationFinal reportBeech D18S · Norfolk, VAThe acft crashed during an ILS approach following an engine power loss while on an air taxi freight flight. The plt related that at about 550 ft on the approach to rwy 23 the left eng fuel press warning lite illuminated & the lt eng loss power. The plt opened…NTSB BFO85FA008Accident · No injuriesField investigationFinal reportBeech C23 · Clifton, VAShortly after leveling at the cruise altitude of 2500 ft, the pilot noted a gradual RPM decrease and resultant loss of power. Altitude could not be maintained and the pilot selected a rolling open field in which to land when he realized that reaching an…NTSB ATL83FA086Accident · Minor injuriesField investigationFinal reportChampion 7ECA · Quinton, VAThe acft crashed shortly after takeoff following an engine malfunction. The student was taking basic instruction in tailwheel acft and had made one landing. Following the 2nd takeoff, at 150-200 feet AGL, the engine lost power with the RPM dropping to the…NTSB ATL82FID13Accident · No injuriesFinal reportBeech B-19 · Franklin, VAN7698R crashed while on final approach, approximately one half mile east of Franklin airport. The father of the pilot stated that the aircraft had been taken without permission. The pilot holds an expired student pilot certificate. In addition, the pilot was…