NTSB investigations: Mooney M20J, AL
6 cases on aircraft the registry lists as Mooney M20J. 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 | 1 |
|---|---|
| 1984 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2005 | 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\" = 'AL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870219'))
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" = 'AL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5870219'))
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 ATL05LA051Accident · Serious injuriesLimited investigationFinal reportMooney 20P · Smith, ALMaintenance personnel failure to properly torque the cylinder head during installation that resulted in the separation from the engine assembly and the subsequent loss of power.NTSB MIA98LA207Accident · No injuriesLimited investigationFinal reportMooney M-20J · Alexander City, ALThe pilot's failure to maintain directional control of the airplane during landing rollout and attempted go-around, resulting in departure from the runway and collision with adjacent brush and trees.NTSB ATL96FA021Accident · 2 fatalField investigationFinal reportMooney M20J · Bay Minette, ALfailure of the alternate air door, which resulted in blockage of air through the induction system. A factor relating to the accident was: failure to comply with Safety Bulletin SB-M20-253.NTSB ATL94LA070Accident · No injuriesLimited investigationFinal reportMooney M20J · Muscle Shoals, ALWas the loose throttle cable, and the pilot's failure to abort the takeoff when the engine did not produce full power. A factor was the inadequate maintenance inspection of the engine.NTSB ATL84FA292Accident · 2 fatalField investigationFinal reportMooney M20J · Lanett, ALCommunications with columbus apch revealed plt was unfamiliar with area and had difficulities finding the arpt witnesses viewed acft on final for rwy 08 with landing gear extended. Acft described as being low and slow. Witnesses stated engine sounds…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…