Skip to content

NTSB investigations · 884

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 ('2071820') 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 ('2071820')
  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 ('2071820')
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 MKC77FER05Accident · No injuriesClosedCessna 150J · Tyler, MNNov 7, 1976 · N60663 · Substantial damage NTSB NYC77DNC05Accident · No injuriesClosedCessna 150J · Howland, MEOct 30, 1976 · N5584G · Substantial damage NTSB LAX77FUG05Accident · No injuriesClosedCessna 150 · Riverside, CAOct 23, 1976 · N51030 · Destroyed NTSB ANC77DAG21Accident · No injuriesClosedCessna 150 · Kodiak, AKOct 14, 1976 · N51355 · Substantial damage NTSB MIA77FA002Accident · 2 fatalClosedCessna 150J · Kissimee, FLOct 11, 1976 · N61083 · Destroyed NTSB FTW76FPA01Accident · No injuriesClosedCessna 150 · Bonham, TXOct 9, 1976 · N5531G · Substantial damage NTSB DEN77FTM04Accident · No injuriesClosedCessna 150J · Kamas, UTOct 9, 1976 · N60605 · Destroyed NTSB CHI76FEK32Accident · No injuriesClosedCessna 150 · Columbus, OHSep 28, 1976 · N51258 · Substantial damage NTSB IAD76FIG27Accident · No injuriesClosedCessna 150 · Silver Springs, MDSep 23, 1976 · N50657 · Substantial damage NTSB FTW76FRF46Accident · No injuriesClosedCessna 150 · Lufkin, TXSep 11, 1976 · N61313 · Substantial damage NTSB NYC76DHD44Accident · No injuriesClosedCessna 150J · Blue Bell, PASep 6, 1976 · N60753 · Destroyed NTSB OAK76DVH07Accident · No injuriesClosedCessna 150 · Paradise, CAAug 21, 1976 · N60001 · Substantial damage NTSB LAX76DUG68Accident · No injuriesClosedCessna 150J · El Monte, CAAug 21, 1976 · N50814 · Substantial damage NTSB CHI76FEE72Accident · No injuriesClosedCessna 150J · Hinckley, ILAug 20, 1976 · N50997 · Substantial damage NTSB FTW76FPG98Accident · Serious injuriesClosedCessna 150J · Batesville, ARAug 14, 1976 · N61074 · Destroyed NTSB SEA77DYE56Accident · No injuriesClosedCessna 150 · Eastsound, WAAug 1, 1976 · N60194 · Destroyed NTSB DEN76DQD31Accident · No injuriesClosedCessna 15OJ · Silver City, NMAug 1, 1976 · N50651 · Destroyed NTSB ANC76DAH57Accident · Minor injuriesClosedCessna 150 · Glennallen, AKAug 1, 1976 · N60386 · Substantial damage NTSB NYC76AN116Accident · 1 fatalClosedCessna 150J · Syosset, NYJul 26, 1976 · N60359 · 2 aircraft · Destroyed NTSB MKC76DER82Accident · No injuriesClosedCessna 150J · Anoka, MNJul 25, 1976 · N60030 · Substantial damage NTSB NYC76AM114Accident · 2 fatalClosedCessna 150J · W Caldwell, NJJul 24, 1976 · N5546G · Destroyed NTSB NYC76FNE29Accident · No injuriesClosedCessna 150J · Southbridge, MAJul 18, 1976 · N60412 · Substantial damage NTSB LAX76DUG61Accident · No injuriesClosedCessna 150 · Chino, CAJul 7, 1976 · N61221 · Substantial damage NTSB MKC76DCD44Accident · No injuriesClosedCessna 150J · Muscatine, IAMay 27, 1976 · N51183 · Substantial damage NTSB SEA76DYC47Accident · No injuriesClosedCessna 150 · Clackamas, ORMay 15, 1976 · N61263 · Substantial damage NTSB CHI76FEE55Accident · Serious injuriesClosedCessna 150J · Plainfield, ILApr 22, 1976 · N61237 · Destroyed NTSB NYC76FHA26Accident · Minor injuriesClosedCessna 150 · Bushkill, PAApr 17, 1976 · N60445 · Substantial damage NTSB CHI76FEK15Accident · No injuriesClosedCessna 150 · Blacklick, OHApr 12, 1976 · N51043 · Substantial damage NTSB IAD76DID24Accident · No injuriesClosedCessna 150J · Farmville, VAApr 11, 1976 · N50936 · Substantial damage NTSB LAX76FUM24Accident · No injuriesClosedCessna 150J · Fallbrook, CAApr 9, 1976 · N50643 · Substantial damage NTSB MIA76DLG27Accident · No injuriesClosedCessna 150J · Georgetown, SCMar 28, 1976 · N60696 · Substantial damage NTSB MKC76FCJ30Accident · No injuriesClosedCessna 150J · Tecumseh, NEMar 18, 1976 · N50467 · Substantial damage NTSB MKC76FER56Accident · Serious injuriesClosedCessna 150J · Rochester, MNMar 10, 1976 · N60038 · Substantial damage NTSB SEA76FTA14Accident · No injuriesClosedCessna 150J · Kinsey, MTMar 1, 1976 · N5625G · Substantial damage NTSB DEN76FTE57Accident · Serious injuriesClosedCessna 150J · Broomfield, COMar 1, 1976 · N51220 · Substantial damage NTSB CHI76FEV26Accident · No injuriesClosedCessna 150J · Cape Girardeau, MOFeb 24, 1976 · N60177 · Substantial damage NTSB MKC76DER52Accident · No injuriesClosedCessna 150J · Lake Elmo, MNFeb 13, 1976 · N61039 · Substantial damage NTSB MIA76FKG41Accident · No injuriesClosedCessna 150J · Tifton, GAFeb 4, 1976 · N50886 · Substantial damage NTSB NYC76FN071Accident · 2 fatalClosedCessna 150 · Long Valley, NJJan 31, 1976 · N99ST · Destroyed NTSB IAD76FIG08Accident · Minor injuriesClosedCessna 150 · Baltimore, MDJan 28, 1976 · N60489 · Substantial damage NTSB NYC76DNC40Accident · No injuriesClosedCessna 150 · Fairhaven, VTJan 25, 1976 · N60939 · Substantial damage NTSB LAX76AL046Accident · 3 fatalClosedCessna 150J · Irvine, CAJan 18, 1976 · N60423 · 2 aircraft · Destroyed NTSB SEA76DYA15Accident · Minor injuriesClosedCessna 150J · Lowman, IDJan 2, 1976 · N51149 · Substantial damage NTSB CHI76FEI16Accident · No injuriesClosedCessna 150 · Elyria, OHDec 17, 1975 · N51306 · Substantial damage NTSB ANC76DAG68Accident · No injuriesClosedCessna 150 · Karluk, AKNov 16, 1975 · N51355 · Substantial damage NTSB MIA76DKT30Accident · No injuriesClosedCessna 150 · Punta Gorda, FLNov 4, 1975 · N50670 · Substantial damage NTSB SEA76AS023Accident · 2 fatalClosedCessna 150J · Grants Pass, OROct 28, 1975 · N50490 · Destroyed NTSB NYC76DFJ11Accident · Minor injuriesClosedCessna 150 · Lockport, NYOct 23, 1975 · N5564G · Substantial damage NTSB CHI76FEM12Accident · No injuriesClosedCessna 150J · Atlanta, MISep 27, 1975 · N60536 · Substantial damage NTSB SEA76DYC15Accident · No injuriesClosedCessna 150 · Battleground, WASep 3, 1975 · N51053 · Substantial damage

Back to Cessna 150J