NTSB investigations: Lockheed 12A
15 cases on aircraft the registry lists as Lockheed 12A. 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 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1974 | 2 |
| 1975 | 2 |
| 1979 | 1 |
| 1990 | 1 |
| 2024 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5261402'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5261402'))
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 ERA24FA266Accident · Serious injuriesClass 3 · FieldFinal reportLockheed 12 · Jackson, GAMaintenance personnel’s failure to properly secure the right brake line, which resulted in a loss of right brake effectiveness during the landing roll and a subsequent runway excursion.NTSB WPR24FA196Accident · 2 fatalClass 3 · FieldFinal reportLockheed 12A · Chino, CAThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall at an altitude insufficient for recovery. Contributing to the accident was the pilot’s failure to ensure that the airplane was…NTSB CHI90FA208Accident · Serious injuriesField investigationFinal reportLockheed 12A · Oshkosh, WIThe inadequate emergency procedure(s) by the pilot in command following a loss of engine power for undetermined reasons(s).NTSB CHI79FEC40Accident · 1 fatalClosedLockheed 12A · Pontiac, MINTSB MKC76FCG25Accident · Serious injuriesClosedLockheed 12A · Springfield, MONTSB LAX76DUG07Accident · No injuriesClosedLockheed 12A · Rubidoux, CANTSB MKC75DCD24Accident · No injuriesClosedLockheed 12A · Osage, IANTSB UNK74X0112Accident · No injuriesClosedLockheed 12A · Q.Roo, MexicoNTSB CHI71FGD30Accident · No injuriesClosedLockheed 12A · Toledo, OHNTSB DEN69A0047Accident · Serious injuriesClosedLockheed 12A · Casper, WYNTSB CHI68D0634Accident · No injuriesClosedLockheed 12A · Gaylord, MINTSB CHI68D0276Accident · No injuriesClosedLockheed 12A · Montello, WINTSB FTW67A0058Accident · No injuriesClosedLockheed 12A · Oklahoma Cty, OKNTSB CHI66D0665Accident · No injuriesClosedLockheed 12A · Richmond Hts, OHNTSB UNK64X2707Accident · 5 fatalClosedLockheed 12A · Martinsville, VA