Skip to content

NTSB investigations, MD

11 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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" = 352) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 352)
  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" = 352)
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 NYC00LA198Accident · Serious injuriesLimited investigationFinal reportWarrington Surrel Guppy · Churchville, MDThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Factors in this accident were an open canopy and a decrease in engine power.Jul 16, 2000 · N4425W · Substantial damage NTSB NYC00LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, MDThe failure of the number 3-cylinder exhaust valve stem due to fatigue cracking.Oct 8, 1999 · N56094 · Substantial damage NTSB NYC97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Preston, MDThe pilot's improper flare during a precautionary landing, which resulted in a hard landing. A factor in the accident was the failure of the left magneto, which resulted in a partial loss of engine power.May 29, 1997 · N4497Y · Substantial damage NTSB BFO93FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edgewater, MDThe pilot's improper in-flight planning/decision after selecting the wrong runway for a precautionary landing , which resulted in an inadvertent descent into transmission lines, while attempting to maneuver back to the runway. Factors related to the accident…Apr 17, 1993 · N56430 · Destroyed NTSB BFO92FA058Accident · 3 fatalField investigationFinal reportCessna 177 · Lusby, MDA failure of the carburetor resulting in a loss of engine power.May 10, 1992 · N177RD · Destroyed NTSB BFO91LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Hagerstown, MDWorn camshaft lobes which resulted in the loss of engine power.Mar 22, 1991 · N5241D · Substantial damage NTSB BFO91LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Hagerstown, MDThe failure of the throttle control cable. A factor ws the rough terrain.Mar 7, 1991 · N6699P · Substantial damage NTSB BFO90FA008Accident · No injuriesField investigationFinal reportPiper PA-28-181 · Laurel, MDLost of engine power caused by material failure of the number three cylinder exhaust valve. The failure was attributed to excessive temperature.Nov 5, 1989 · N47759 · Substantial damage NTSB BFO87MA007Accident · 1 fatalMajor investigationFinal reportBeech 65-A80 · Baltimore, MDDrg clb after tkof, l eng seized. Plt said he atmtd 1 eng restart; prop would not rotate or feather. No emerg declared. Plt stated eng shut-dwn proc was used, scientific bus sws were shut off, r gen was recycled & appeared to oper normally. Plts got imt…Nov 8, 1986 · N304D · Destroyed NTSB BFO86LA040Accident · No injuriesLimited investigationFinal reportCessna 172L · Aberdeen, MDThe plt stated that the eng began to run rough during flt, then all at once, it started vibrating excessively. He attempted to land at the phillips aaf, but the arpt was closed & the rwy lights were not illuminated. By the time he saw the rwy, the acft was…Jul 16, 1986 · N3933Q · Destroyed NTSB ATL82DA106Accident · Minor injuriesFinal reportBeech B19 · College Park, MDDuring the preflight the pilot noted the engine ran rough on the right magneto then smoothed out. The pilot departed the runway with the stall warning horn sounding and began a turn into the wind; however, due to buildings in his path he turned 360 degrees.…Apr 17, 1982 · N1932W · Substantial damage