NTSB investigations: Cessna 140, NM
21 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1981 | 1 |
| 1983 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1999 | 1 |
| 2022 | 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\" = 'NM' 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" = 'NM' 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" 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 WPR22LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Estancia, NMThe pilot’s decision to land on an unsuitable surface which resulted in his loss of aircraft control.NTSB DEN99LA088Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMThe pilot's excessive use of rudder while attempting to correct for loss of directional control. Factors were the pilot's loss of directional control, and his lack of experience in the type of airplane.NTSB FTW94LA062Accident · No injuriesLimited investigationFinal reportCessna 140 · Espanola, NMWas the dual student pilot's failure to maintain directional control. A factor was the certificated flight instructor's inadequate supervision.NTSB DEN90LA171Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Silver City, NMThe pilot's improper planning which resulted in a flight in conditions which exceeded the performance capability of the aircraft. The high density altitude was a factor.NTSB DEN89LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMImproper use of brakes which resulted in an inadvertent ground swerve.NTSB DEN87LA244Accident · No injuriesLimited investigationFinal reportCessna 140 · San Ysidro, NMThe plt and pax were on a LCL sightseeing flt. The plt stated that he had been flying low and slow at a nose high attitude. The engine began to overheat and did not cool off and the pilot executed a precautionary landing on a dirt road. The acft ballooned and…NTSB DEN86FA207Accident · Serious injuriesField investigationFinal reportCessna 140 · Taos, NMN76541 took off on rwy 04 on a high density altitude day. The acft was seen climbing with the nose high near the departure end of the rwy. The acft just cleared some electrical lines near the end of the rwy and then was observed to descend down to a height…NTSB FTW84LA079Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Los Lunas, NMThis was to be the student's first flt & the CFI had him follow through on the controls. As the tail came off the rwy the student began overpowering the CFI at the controls. The CFI was unable to maintain directional control & the acft went off the rwy into a…NTSB FTW83LA367Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Alamagordo, NMAfter topping the acft with fuel, the plt took of from the 4200 ft high rwy, toward the mountains. The density alt at that time was about 6700 ft. during the takeoff, the plt rotated at 50 mph, then accelerated in ground effect to 70 mph. He then started to…NTSB FTW81FQA37Accident · No injuriesClosedCessna 140 · Albuquerque, NMNTSB DEN75DQA38Accident · No injuriesClosedCessna 140 · Los Alamos, NMNTSB DEN72DQA01Accident · No injuriesClosedCessna 120 · Raton, NMNTSB DEN71DQA48Accident · No injuriesClosedCessna 140 · Santa Fe, NMNTSB DEN70FQA11Accident · Serious injuriesClosedCessna 140 · Los Alamos, NMNTSB DEN70F0035Accident · Serious injuriesClosedCessna 140 · Gallup, NMNTSB DEN69D0252Accident · No injuriesClosedCessna 140 · Shiprock, NMNTSB DEN69D0145Accident · No injuriesClosedCessna 140 · Albuquerque, NMNTSB DEN68F0144Accident · No injuriesClosedCessna 140 · Crown Pt, NMNTSB DEN66D0334Accident · No injuriesClosedCessna 140 · Las Cruces, NMNTSB DEN66D0025Accident · No injuriesClosedCessna 140 · Clovis, NMNTSB UNK64X3425Accident · No injuriesClosedCessna 140 · Farmington, NM