NTSB investigations: Cessna 140, PA
30 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 | 3 |
|---|---|
| 1965 | 3 |
| 1966 | 3 |
| 1967 | 3 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2021 | 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\" = 'PA' 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" = 'PA' 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 ERA21LA348Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Bloomsburg, PAThe pilot’s loss of directional control during the landing rollout, which resulted in a runway excursion and impact with terrain.NTSB NYC95FA162Accident · 1 fatalField investigationFinal reportCessna 140 · Danielsville, PAThe flight crew's improper in-flight planning/decision, and failure to maintain adequate clearance (or altitude) from mountainous terrain. Factors relating to the accident were: darkness, fog, low clouds, and the high terrain.NTSB BFO94LA072Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Clarion, PAThe pilot's failure to maintain directional control which resulted in an overrun of the runway and collision with a berm.NTSB NYC93LA072Accident · 1 fatalLimited investigationFinal reportCessna 140 · Doylestown, PAFailure of the pilot passenger to maintain adequate airspeed and the failure of the pilot in command to adequately supervise the flight.NTSB NYC85LA119Accident · No injuriesLimited investigationFinal reportCessna 140 · Latrobe, PAThe plt reported that during a landing, the acft began to swerve to the right. At about the time he was regaining control, the left gear spring (strut), pn Q441138, failed. Subsequently, the acft went off the rwy & the left wing was damaged. An exam of the…NTSB NYC84LA324Accident · No injuriesLimited investigationFinal reportCessna 140 · Harrisburg, PAAcft was landed downwind in light wind conditions by student plt. On roll-out, after normal braking was applied for deceleration, acft began to drift right. Student applied left brake as CFI also applied corrective left brake. Left brake connecting rod failed…NTSB NYC84LA132Accident · No injuriesLimited investigationFinal reportCessna 140 · Jeanette, PAOne of the aircrew members was buying the acft & was receiving dual instruction before flying solo. After several landings, he flared for a 3-point landing. During the landing roll, the acft began drifting left & the student correctedback to the right. The…NTSB NYC82FGM06Accident · No injuriesClosedCessna 140 · Newry, PANTSB NYC80FHA09Accident · Minor injuriesClosedCessna 140 · Slatington, PANTSB NYC80FGM09Accident · No injuriesClosedCessna 140 · Butler, PANTSB NYC76DHA14Accident · Minor injuriesClosedCessna 140 · New Milford, PANTSB NYC73FGT14Accident · No injuriesClosedCessna 140 · Thomasville, PANTSB NYC73FHA05Accident · No injuriesClosedCessna 140 · Montgmeryville, PANTSB NYC73FGM05Accident · Minor injuriesClosedCessna 140 · Slippery Rock, PANTSB NYC72FHA02Accident · Minor injuriesClosedCessna 140 · Line Lexington, PANTSB NYC71DGM49Accident · No injuriesClosedCessna 140 · Clarion, PANTSB NYC70F0132Accident · No injuriesClosedCessna 140 · Hellertown, PANTSB NYC69D0184Accident · No injuriesClosedCessna 140 · Penn Run, PANTSB NYC68F0279Accident · No injuriesClosedCessna 140 · Bedford, PANTSB NYC68D0040Accident · No injuriesClosedCessna 140 · Corry, PANTSB NYC67D0553Accident · No injuriesClosedCessna 140 · West Chester, PANTSB NYC67F0341Accident · No injuriesClosedCessna 140 · Danville, PANTSB NYC66D0568Accident · No injuriesClosedCessna 140 · Corry, PANTSB NYC66F0513Accident · Minor injuriesClosedCessna 140 · Bellefonte, PANTSB NYC66F0230Accident · No injuriesClosedCessna 140 · Keating, PANTSB NYC66F0019Accident · No injuriesClosedCessna 140 · Zelienople, PANTSB NYC65F0068Accident · No injuriesClosedCessna 140 · Prospectville, PANTSB UNK65X0196Accident · No injuriesClosedCessna 140 · Slate Run, PANTSB UNK64X3869Accident · Minor injuriesClosedCessna 140 · Mt Pleasant, PANTSB UNK64X2537Accident · No injuriesClosedCessna 140 · Collegeville, PA