NTSB investigations: Mooney M20J
16 cases on aircraft the registry lists as Mooney M20J, where the first occurrence was “In flight collision with terrain/water”. 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 2 |
| 1988 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 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 ('5870219')
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\" = 230))
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 ('5870219')
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" = 230))
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 LAX07FA080Accident · 1 fatalField investigationFinal reportMooney M20J · Ranchita, CAThe pilot's failure to maintain terrain clearance during a cruise descent. Contributing to the accident were the dark night lighting conditions and the mountainous terrain.NTSB ATL05CA030Accident · No injuriesData collectionFinal reportMooney M20J · Statesville, NCthe flight instructors improper use of the flight controls on rotation during a short field takeoff resulting in the airplane becoming airborne, stall, and collision with the ground. A factor in the accident was the instructors failure to brief procedures for…NTSB DEN04FA003Accident · 2 fatalField investigationFinal reportMooney M20J · Grantsville, UTthe pilot's failure to maintain an adequate visual outlook during low level flight maneuvers that resulted in a collision with terrain. A contributing factor was the pilot's attention being diverted.NTSB IAD02LA070Accident · No injuriesLimited investigationFinal reportMooney M20J · Ocean City, NJThe pilot's improper recovery from a bounced landing, and his inadequate compensation for wind. A factor was a wind gust.NTSB CHI02LA154Accident · No injuriesLimited investigationFinal reportMooney M20J · Minneapolis, MNThe pilot's failure to maintain control of the aircraft during an aborted landing.NTSB NYC01LA191Accident · No injuriesLimited investigationFinal reportMooney M20J · East Greenwich, NJThe pilot's premature liftoff which resulted in an inadvertent stall.NTSB FTW98FA354Accident · 1 fatalField investigationFinal reportMooney M20J · Centennial, WYThe pilot's disregard of information provided in weather briefs, and his flight into known adverse weather in mountainous terrain which resulted in an in-flight collision with a mountain. Factors were rain and low ceiling/visibility.NTSB LAX98FA050Accident · 2 fatalField investigationFinal reportMooney M20J · Sedona, AZthe failure of the pilot to maintain adequate terrain clearance during the climb. Contributing factors were dark night conditions, mountainous/hilly terrain, and mountain wave weather conditions.NTSB NYC94LA049Accident · 3 fatalLimited investigationFinal reportMooney M20J · Jones Beach, NYwas the pilot's failure to maintain control of the airplane, resulting in the airplane impacting with the water. Also casual in this accident was the pilot's total lack of experience in this type of aircraft, and operations. A factor in this accident was the…NTSB NYC91LA226Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Nantucket, MAThe pilot's descent below the ILS glide path and his delay in initiating a missed approach which resulted in collision with the terrain.NTSB NYC88LA088Accident · Serious injuriesLimited investigationFinal reportMooney M20 · Morristown, NJThe Mooney crashed while on a ILS approach at night. The plt had been unable to get into two other airports due to weather and air traffic. The aircraft impacted in swampy area. The pilot had told ATC that he felt uneasy about his engine; however, he did not…NTSB FTW86FPA05Accident · Minor injuriesFinal reportMooney MK20J · Gladewater, TXDuring takeoff the headset wiring became tangled in the emergency gear extension handle which had been accidently activated. Then the normal gear handle was put in the up position, the emergency gear crank rotated pulling on the headset and the emergency gear…NTSB LAX85FA314Accident · 1 fatalField investigationFinal reportMooney M20J · Antioch, CAThe acft crashed into a reservoir shortly after departing the Antioch arpt. There were no eye witnesses to the crash. However, an ear witness stated that he heard the acft skipping along the water like the sound of a hydro-plane. He did not hear the eng, but…NTSB DEN83LA173Accident · No injuriesLimited investigationFinal reportMooney M20J · Aurora, COThe arpt had one asphalt rwy that was closed & another dirt rwy that was muddy. Therefore, the plt elected to takeoff on the parking ramp which was oriented in a north/south direction & was 1700 ft long. The plt did not consult the takeoff charts in his…NTSB ATL83FA036Accident · 1 fatalField investigationFinal reportMooney M20J · Sardis, ALThe aircraft was on an IFR flight from memphis, TN to selma, AL. During arrival, he was cleared for an NDB approach to the craig airport. At that time, the weather was reported as measured 400 ft overcast, visibility 1/2 mi with fog. The weather minimums for…NTSB NYC82DA213Accident · No injuriesFinal reportMooney M20J · Matawan, NJThe pilot stated that he had never been at this airport before. During arrival, he landed on runway 27 toward the setting sun with a crosswind from the left. He stated that he touched down firmly on the first 1/3 of the runway, then the aircraft floated…