Skip to content

NTSB investigations: Mooney M20A, TX

25 cases on aircraft the registry lists as Mooney M20A. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'TX' 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 ('5870204')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'TX' 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 ('5870204'))
  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" = 'TX' 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 ('5870204'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN23LA289Accident · No injuriesClass 4 · LimitedFinal reportMooney M20A · Frankston, TXThe pilot’s failure to maintain directional control during landing.Jul 8, 2023 · N8335E · Substantial damage NTSB FTW00LA122Accident · No injuriesLimited investigationFinal reportMooney M20A · Houston, TXThe pilot's delayed go-around and his failure to maintain the aircraft's clearance with trees.Apr 5, 2000 · N8159E · Substantial damage NTSB FTW85LA172Accident · No injuriesLimited investigationFinal reportMooney M20A · Austin, TXThe 86 hr private plt landed at a ranch and ran off the end of the rwy into rough terrain. A go around was not attempted.Apr 2, 1985 · N8121E · Substantial damage NTSB FTW82FPD17Accident · Serious injuriesFinal reportMooney M20 · Abilene, TXAt about 50-75 ft AGL after takeoff the eng quit. Both tanks contained adequate fuel & no eng malfunctions were found.Jul 30, 1982 · N8393E · Destroyed NTSB FTW82FRG28Accident · Serious injuriesFinal reportMooney M20A · San Antonio, TXDuring arrival, the pilot entered the traffic pattern for a landing on runway 30 with a 7 knot tailwind. On final approach, he was not satisfied with his pattern and elected to go-around. During the go-around and climb, a map and checklist fell into the…May 2, 1982 · N7836C · Destroyed NTSB FTW79DRA13Accident · No injuriesClosedMooney M20A · Tomball, TXMar 25, 1979 · N6556B · Substantial damage NTSB FTW74FRA20Accident · Minor injuriesClosedMooney M20A · Huntsville, TXNov 3, 1973 · N6032X · Substantial damage NTSB FTW74FRG02Accident · No injuriesClosedMooney M20 · Corpus Chrsti, TXJul 3, 1973 · N6536B · Substantial damage NTSB FTW72FRA25Accident · No injuriesClosedMooney M20A · Houston, TXNov 20, 1971 · N8379E · Substantial damage NTSB FTW71FRA60Accident · Minor injuriesClosedMooney M20A · Spring Branch, TXMay 25, 1971 · N6073X · Substantial damage NTSB FTW69D0304Accident · No injuriesClosedMooney M20A · Grand Prairie, TXNov 17, 1968 · N8325E · Substantial damage NTSB FTW69F0294Accident · No injuriesClosedMooney M20A · Fort Worth, TXNov 16, 1968 · N6062X · Substantial damage NTSB FTW68F0489Accident · Minor injuriesClosedMooney M20A · Garland, TXMar 26, 1968 · N1069C · Substantial damage NTSB FTW68F0492Accident · No injuriesClosedMooney M20A · Kingsville, TXFeb 24, 1968 · N8330E · Substantial damage NTSB FTW68F0320Accident · No injuriesClosedMooney 20A · Kingsville, TXOct 19, 1967 · N8330E · Substantial damage NTSB FTW68F0279Accident · Minor injuriesClosedMooney M20A · Plano, TXOct 5, 1967 · N8194E · Substantial damage NTSB FTW67D0593Accident · No injuriesClosedMooney M20A · Greenville, TXMay 11, 1967 · N6596B · Substantial damage NTSB FTW67D0398Accident · No injuriesClosedMooney M20A · Kingsville, TXFeb 11, 1967 · N8330E · Substantial damage NTSB FTW67D0439Accident · No injuriesClosedMooney M20A · Chandler, TXJan 1, 1967 · N6547B · Substantial damage NTSB FTW67D0355Accident · No injuriesClosedMooney M20A · Cumby, TXDec 4, 1966 · N6596B · Substantial damage NTSB FTW67F0074Accident · No injuriesClosedMooney M20A · El Paso, TXJul 16, 1966 · N6580B · Substantial damage NTSB FTW66F0568Accident · Minor injuriesClosedMooney M20A · Orange, TXFeb 13, 1966 · N8108E · Substantial damage NTSB FTW66F0353Accident · No injuriesClosedMooney M20A · Dallas, TXOct 13, 1965 · N8132E · Substantial damage NTSB FTW65A0087Accident · 1 fatalClosedMooney M20A · Bedias, TXMar 1, 1965 · N1088C · Destroyed NTSB UNK65X0233Accident · No injuriesClosedMooney M20A · Ft Worth, TXOct 11, 1964 · N6587B · Substantial damage