NTSB investigations: Mooney M20E, AL
12 cases on aircraft the registry lists as Mooney M20E. 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
| 1967 | 2 |
|---|---|
| 1968 | 1 |
| 1970 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1984 | 3 |
| 1985 | 1 |
| 1986 | 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 ('5870212'))
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 ('5870212'))
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 ATL86LA157Accident · No injuriesLimited investigationFinal reportMooney M20E · Pell City, ALThe eng lost pwr and a forced landing was made aprx 5 miles south of the destination arpt. The plt reported that, prior to departure he visually examined the fuel tanks and estimated having aprx 9 gals total fuel onboard. He estimated that only 5 gals would…NTSB ATL85LA131Accident · No injuriesLimited investigationFinal reportMooney M20E · Gunthersville, ALThe plt reported that he failed to extend the landing gear in the traffic pattern. Subsequently, the acft was damaged during a gear up landing.NTSB ATL85LA065Accident · No injuriesLimited investigationFinal reportMooney M20E · Monroeville, ALPlt unable to electrically or manually fully extend landing gear in traffic pattern so he decided to make a gear up landing. Unknowingly plt had lowered gear to a transit position and gear collapsed on landing. Plt had previous problems with gear and had to…NTSB ATL84LA196Accident · No injuriesLimited investigationFinal reportMooney M20E · Seale, ALThe plt approached downwind at 80 mph with full flaps. At touchdown the acft bounced and floated about 600 ft before a 2nd touchdown. When the acft could not be stopped on the short grass rwy, it was groundlooped to stay on the arpt. During the groundloop the…NTSB ATL84LA149Accident · No injuriesLimited investigationFinal reportMooney 21 · Centre, ALWhile in cruise flt the engine failed. The pilot executed a forced landing, and the acft sustained substantial damage during the landing sequence. Examination of the acft revealed no fuel in the tanks, lines, or pump. The acft had flown about 5 hours since…NTSB MIA78DKJ19Accident · No injuriesClosedMooney M20E · Gadsden, ALNTSB MIA76FKJ41Accident · Minor injuriesClosedMooney M20E · Alabaster, ALNTSB MIA73DKJ63Accident · Minor injuriesClosedMooney M20E · Camden, ALNTSB MIA70DKJ46Accident · No injuriesClosedMooney M20E · Greenville, ALNTSB MIA68F0428Accident · No injuriesClosedMooney M20E · Gadsden, ALNTSB MIA68F0155Accident · No injuriesClosedMooney M20E · Loachapoka, ALNTSB MIA68D0119Accident · No injuriesClosedMooney M20 · Birmingham, AL