Skip to content

NTSB investigations · 17

Matched to the registry by N-number and event date, newest first.

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('5261402') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('5261402')
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 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.Jun 17, 2024 · N2072 · Substantial damage 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…Jun 15, 2024 · N93R · Substantial damage NTSB ATL01LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Homer, GAThe loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.Oct 14, 2000 · N18130 · Substantial damage 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).Jul 31, 1990 · N12AT · Destroyed NTSB CHI79FEC40Accident · 1 fatalClosedLockheed 12A · Pontiac, MIAug 7, 1979 · N36P · Destroyed NTSB MKC76FCG25Accident · Serious injuriesClosedLockheed 12A · Springfield, MOSep 15, 1975 · N3486 · Substantial damage NTSB LAX76DUG07Accident · No injuriesClosedLockheed 12A · Rubidoux, CAJul 14, 1975 · N71K · Substantial damage NTSB MKC75DCD24Accident · No injuriesClosedLockheed 12A · Osage, IANov 21, 1974 · N18137 · Substantial damage NTSB UNK74X0112Accident · No injuriesClosedLockheed 12A · Q.Roo, MexicoJun 24, 1974 · N36P · Substantial damage NTSB NYC74FNE13Accident · No injuriesClosedCessna 150L · Chester, CTDec 1, 1973 · N18130 · Substantial damage NTSB CHI71FGD30Accident · No injuriesClosedLockheed 12A · Toledo, OHJul 6, 1970 · N18137 · Substantial damage NTSB DEN69A0047Accident · Serious injuriesClosedLockheed 12A · Casper, WYMay 9, 1969 · N399X · Substantial damage NTSB CHI68D0634Accident · No injuriesClosedLockheed 12A · Gaylord, MIFeb 3, 1968 · N36P · Substantial damage NTSB CHI68D0276Accident · No injuriesClosedLockheed 12A · Montello, WIAug 10, 1967 · N4001 · Substantial damage NTSB FTW67A0058Accident · No injuriesClosedLockheed 12A · Oklahoma Cty, OKDec 1, 1966 · N16085 · Substantial damage NTSB CHI66D0665Accident · No injuriesClosedLockheed 12A · Richmond Hts, OHMar 4, 1966 · N1108 · Substantial damage NTSB UNK64X2707Accident · 5 fatalClosedLockheed 12A · Martinsville, VAJul 7, 1964 · N18946 · Destroyed

Back to Lockheed 12A