NTSB investigations: Mooney M20K
13 cases on aircraft the registry lists as Mooney M20K, where the first occurrence was “Loss of engine power(total) - nonmechanical”. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1987 | 1 |
|---|---|
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870220')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870220')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 MIA08FA010Accident · 1 fatalField investigationFinal reportMooney M20K · Panama City, FLThe pilot's inadequate preflight inspection which resulted in a loss of engine power during cruise flight due to fuel contamination. A factor was the pilot's impairment due to recent cocaine use.NTSB DEN07CA070Accident · No injuriesData collectionFinal reportMooney M20K · Ingalls, KSThe pilot's inadequate in-flight planning and decision making, and failure to refuel while en route, resulting in loss of engine power during cruise due to fuel exhaustion. Contributing to the accident was the poor weather at the pilot's destination.NTSB SEA06FA038Accident · 1 fatalField investigationFinal reportMooney M20K · North Plains, ORThe pilot's failure to maintain airspeed while maneuvering for a forced landing, resulting in a stall-spin and uncontrolled descent to ground impact. A contributing factor was the loss of engine power due to fuel exhaustion resulting from the pilot's…NTSB CHI05CA170Accident · No injuriesData collectionFinal reportMooney M20K · Kennett, MOThe fuel starvation, inadequate preflight planning and preparation, and inadequate in-flight planning/decision by the pilot.NTSB ATL04LA017Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Carrollton, GAA loss of engine power for undetermined reasons.NTSB DEN03LA024Accident · No injuriesLimited investigationFinal reportMooney M20K · Eagle, COthe pilot's failure to remove protective coverings from the engine air scoops during the preflight inspection, resulting in air starvation and a loss of engine power shortly after takeoff. A contributing factor was the lack of suitable terrain for a forced…NTSB CHI01LA088Accident · No injuriesLimited investigationFinal reportMooney M20K · New Hudson, MIInadequate preflight planning/preparation which resulted in an adequate fuel supply for the flight and subsequently in fuel starvation. A factor associated with the accident was the steep bank which the airplane contacted during the forced landing.NTSB LAX97LA282Accident · No injuriesLimited investigationFinal reportMooney M20K · Lakeport, CAthe pilot's inadequate preflight by failing to ensure that the fuel selector was positioned to a tank containing fuel, which resulted in fuel starvation, and a forced landing shortly after takeoff.NTSB NYC96LA087Accident · Serious injuriesLimited investigationFinal reportMooney M20K · West Milford, NJloss of engine power for undetermined reason(s), which resulted in a forced landing on unsuitable terrain and subsequent collision with trees.NTSB BFO93LA015Accident · No injuriesLimited investigationFinal reportMooney M20K · Orange, VAWater contamination in the fuel, and inadequate preflight inspection.NTSB MIA90LA065Accident · Serious injuriesLimited investigationFinal reportMooney M-20K-231 · Winter Haven, FLThe pilot in command failed to properly pre-flight the airplane and assure that an adequate fuel supply was onboard to complete the intended flight. This resulted in an engine failure due to fuel exhaustion.NTSB CHI88FAMS2Accident · Serious injuriesMissing aircraftFinal reportMooney M20K · Racine, WIEngine failure due to fuel starvation.NTSB LAX87FA198Accident · No injuriesField investigationFinal reportMooney M20K · Long Beach, CAOn 4/28/87, after a flt from Long Beach to las vegas, the plt requested the left wing tank be svcd with 15 gal of fuel; no fuel was added to the rgt tank. Two days later, the plt took off on the return flt. Drg arrival at Long Beach, he was vectored for an…