NTSB investigations: Mooney M20C
12 cases on aircraft the registry lists as Mooney M20C, where the first occurrence was “In flight collision with object”. 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2004 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870208')
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\" = 220))
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 ('5870208')
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" = 220))
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 SEA07LA177Accident · 2 fatalLimited investigationFinal reportMooney M20C · Price, UTThe pilot's failure to maintain clearance from power transmission lines while on a night straight-in visual flight rules approach. Factors include a power transmission line about one and three-tenths mile off the approach end of the runway, and the pilot's…NTSB DEN04LA065Accident · No injuriesLimited investigationFinal reportMooney M20C · Clovis, NMthe pilot's improper in-flight planning and decision making during an instrument approach resulting in the pilot's intentional descent below approach minimums, and the pilot's failure to maintain obstacle clearance resulting in the in-flight collision with an…NTSB NYC01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Somerset, MAThe pilot's inadequate visual lookout. A factor was the dusk lighting conditions.NTSB FTW00LA037Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Hillsboro, TXThe pilot's failure to maintain directional control of the airplane during the go-around. A factor was the gust of wind.NTSB BFO94LA106Accident · No injuriesLimited investigationFinal reportMooney M20C · Leesburg, VAThe pilot's failure to maintain the minimum descent altitude until the published approach fix. Factors related to the accident was pilot fatigue, low ceilings, obscuration, and fog.NTSB SEA94LA145Accident · No injuriesLimited investigationFinal reportMooney M20C · Wamsutter, WYClearance not maintained. A factor to the accident was: transmission wire.NTSB LAX94LA055Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Santa Paula, CAThe pilot's failure to follow proper procedures/directives prohibiting night operations at the airport and failure to maintain the proper glidepath. The pilot's diverted attention was a factor in this accident.NTSB NYC88LA211Accident · Minor injuriesLimited investigationFinal reportMooney M20C · E. Stroudsburg, PAThe plt said that during an attempted landing the acft floated during the flare. After using about half the rwy he decided to go-around. The temp was 90 deg f resulting in a density alt of 3200 ft. the plt said he applied full pwr but the acft did not climb…NTSB FTW88LA001Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bulverde, TXOn the second approach after a go-around, the aircraft landed approximately halfway down the 2850 ft runway. In an attempt to go around the pilot applied power. The aircraft started to climb but collided with the top of a tree causing the tail of the aircraft…NTSB NYC87LA034Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Jackman, METhe pilot attempted a landing on a runway marked with a x. the runway was closed because it had been extended and was very close to some powerlines. The pilot hit the power lines on final and the aircraft received substantial damage. The pilot was seriously…NTSB NYC86LA010Accident · No injuriesLimited investigationFinal reportMooney M20C · Ocean City, NJThe acft collided with a bird while descending for an apch to landing at Ocean City. Substantial damage resulted to the right horizontal stabilizer. The plt was able to maintain control of the acft with difficulty. A successful landing was accomlished. .NTSB MKC84LA230Accident · No injuriesLimited investigationFinal reportMooney M20C · Hannibal, MON7702M experienced an electrical failure en route & diverted to Hannibal. Plt stated he circled the arpt, saw no traffic& decided to land to the south. N38455 had just landed to the north and was on the rwy when the plt saw N7702M attempting to land in the…