NTSB investigations: Cessna 140, MS

14 cases on aircraft the registry lists as Cessna 140. 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

NTSB investigations: Cessna 140, MS per year, 1964–2026: 14 cases
1964	1
1965	2
1966	2
1967	2
1968	1
1975	1
1977	1
1980	1
1983	1
1995	1
2015	1

Where

Open the map

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" = 'MS' 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 ('2071602', '2071603')) 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\" = 'MS' 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 ('2071602', '2071603'))
  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" = 'MS' 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 ('2071602', '2071603'))
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 GAA15CA042Accident · Minor injuriesData collectionFinal reportCessna 140 · Mize, MSThe pilot's failure to maintain clearance from obstacles during an off airport precautionary landing roll.Apr 18, 2015 · N76452 · Substantial damage NTSB MIA95LA113Accident · No injuriesLimited investigationFinal reportCessna 140 · Foxworth, MSThe pilot-in-command's selection of an unuitable landing strip for landing.Apr 14, 1995 · N3625V · Substantial damage NTSB ATL83FKQ02Accident · Serious injuriesFinal reportCessna 140 · New Albany, MSThe student plt was instructed to make 1 or 2 landings after returning from a solo cross-country flt. He was unable to recall details of the accident, but his wife was at the airport & was a witness. According to her, the plt made a go-around on his first…May 10, 1983 · N76379 · Substantial damage NTSB MIA80FKQ04Accident · No injuriesClosedCessna 140 · Drew, MSMar 23, 1980 · N76653 · Substantial damage NTSB MIA77FLT03Accident · Minor injuriesClosedCessna 140 · Walls, MSMay 6, 1977 · N2301V · Destroyed NTSB MIA76FKQ22Accident · Minor injuriesClosedCessna 140 · Philip, MSOct 21, 1975 · N76515 · Destroyed NTSB MIA69F0125Accident · Serious injuriesClosedCessna 140 · Oakland, MSAug 30, 1968 · N76997 · Destroyed NTSB MIA68F0117Accident · No injuriesClosedCessna 140 · State Coll., MSAug 3, 1967 · N76151 · Substantial damage NTSB MIA67F0452Accident · No injuriesClosedCessna 140 · Amory, MSMar 5, 1967 · N2194N · Substantial damage NTSB MIA67D0010Accident · Minor injuriesClosedCessna 140 · Cherau, MSJun 29, 1966 · N2581N · Substantial damage NTSB MIA66D0530Accident · Minor injuriesClosedCessna 140 · Eupora, MSMay 1, 1966 · N76653 · Substantial damage NTSB MIA66F0218Accident · No injuriesClosedCessna 140 · Meridian, MSSep 4, 1965 · N2020V · Substantial damage NTSB MIA65F0006Accident · No injuriesClosedCessna 140 · Batesville, MSMar 8, 1965 · N72717 · Substantial damage NTSB UNK65X0347Accident · No injuriesClosedCessna 140 · Horn Lake, MSOct 20, 1964 · N2274N · Substantial damage