Skip to content

NTSB investigations · 1,496

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 ('2071826') 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 ('2071826')
  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 ('2071826')
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 LAX77DUJ20Accident · No injuriesClosedCessna 150 · Winslow, AZJan 19, 1977 · N11819 · Substantial damage NTSB NYC77FGM10Accident · No injuriesClosedCessna 150L · Corry, PAJan 9, 1977 · N6849G · Substantial damage NTSB LAX77FA022Accident · 2 fatalClosedCessna 150L · Altadena, CAJan 9, 1977 · N1227Q · Destroyed NTSB OAK77FVA13Accident · Minor injuriesClosedCessna 150L · Madera, CADec 31, 1976 · N5419Q · Destroyed NTSB MKC77DCJ07Accident · No injuriesClosedCessna 150 · Omaha, NEDec 29, 1976 · N16210 · Substantial damage NTSB MIA77DLD20Accident · No injuriesClosedCessna 150 · Vero Beach, FLDec 24, 1976 · N18594 · Substantial damage NTSB IAD77DLQ04Accident · Minor injuriesClosedCessna 150 · Trenton, KYDec 22, 1976 · N11269 · Destroyed NTSB MIA77DKT10Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLDec 11, 1976 · N19075 · Substantial damage NTSB DEN77FTE09Accident · No injuriesClosedCessna 150 · Boulder, CODec 11, 1976 · N11961 · Substantial damage NTSB LAX77FUJ11Accident · Minor injuriesClosedCessna 150 · Mesa, AZDec 8, 1976 · N5433Q · Substantial damage NTSB LAX77FUG14Accident · Serious injuriesClosedCessna 150 · Etiwanda, CADec 7, 1976 · N66012 · Substantial damage NTSB NYC77DFA08Accident · No injuriesClosedCessna 150 · Kingston, NYDec 5, 1976 · N6738G · Substantial damage NTSB MIA76FA008Accident · 1 fatalClosedCessna 150L · Orlando, FLNov 16, 1976 · N7511G · Destroyed NTSB SEA77FYA06Accident · Minor injuriesClosedCessna 150L · Mountain Home, IDNov 14, 1976 · N6788G · Substantial damage NTSB LAX77DUM07Accident · No injuriesClosedCessna 150 · Rancho Snta Fe, CANov 6, 1976 · N6768G · Substantial damage NTSB FTW77FA011Accident · 1 fatalClosedCessna 150 · Denton, TXNov 6, 1976 · N1336Q · 2 aircraft · Destroyed NTSB ANC76DAH09Accident · No injuriesClosedCessna 150 · Summit, AKNov 6, 1976 · N19366 · Substantial damage NTSB CHI77FEV03Accident · No injuriesClosedCessna 150L · Marion, ILOct 27, 1976 · N1611Q · Substantial damage NTSB CHI77FEM08Accident · No injuriesClosedCessna 150L · Sparta, MIOct 25, 1976 · N17236 · Destroyed NTSB ANC77DAA02Accident · No injuriesClosedCessna 150 · Galena, AKOct 14, 1976 · N19251 · Substantial damage NTSB LAX77FVA07Accident · 1 fatalClosedCessna 150 · Kernville, CAOct 10, 1976 · N1402Q · Substantial damage NTSB MIA77FLD03Accident · No injuriesClosedCessna 150L · Merritt Island, FLOct 3, 1976 · N6868G · Substantial damage NTSB CHI77FEM06Accident · No injuriesClosedCessna 150 · Lansing, MIOct 3, 1976 · N10747 · Substantial damage NTSB CHI76DEP51Accident · Minor injuriesClosedCessna 150 · Boscobel, WISep 22, 1976 · N11106 · Destroyed NTSB NYC76FGM50Accident · No injuriesClosedCessna 150L · Beaver Falls, PASep 19, 1976 · N17266 · Substantial damage NTSB OAK76DVA89Accident · No injuriesClosedCessna 150L · Visalia, CASep 14, 1976 · N18014 · Substantial damage NTSB OAK76DVH13Accident · No injuriesClosedCessna 150 · Wolf, CASep 13, 1976 · N5342Q · Destroyed NTSB MKC76DER96Accident · No injuriesClosedCessna 150 · Cambridge, MNSep 6, 1976 · N16078 · Substantial damage NTSB CHI76DBM56Accident · No injuriesClosedCessna 150 · Chesaning, MISep 5, 1976 · N16109 · Substantial damage NTSB SEA76DYIIOAccident · No injuriesClosedCessna 150 · Roseburg, ORSep 2, 1976 · N11758 · Substantial damage NTSB MIA76FKQ48Accident · No injuriesClosedCessna 150L · Meridian, MSAug 29, 1976 · N6647G · Substantial damage NTSB CHI76AC088Accident · 2 fatalClosedCessna 150L · Woodstock, ILAug 25, 1976 · N1452Q · Destroyed NTSB FTW76AF117Accident · 2 fatalClosedCessna 150 · Pflugerville, TXAug 24, 1976 · N11941 · Destroyed NTSB CHI76FEA48Accident · No injuriesClosedCessna 150L · Greenwood, INAug 21, 1976 · N6956G · Substantial damage NTSB MKC76DCQ72Accident · No injuriesClosedCessna 150 · Clyde, KSAug 7, 1976 · N19443 · Substantial damage NTSB ANC76DAH46Accident · No injuriesClosedCessna 150 · Cantwell, AKAug 3, 1976 · N17035 · Substantial damage NTSB MKC76DCQ68Accident · No injuriesClosedCessna 150 · Flush, KSAug 1, 1976 · N19380 · Substantial damage NTSB MKC76DCD59Accident · No injuriesClosedCessna 150 · Leighton, IAAug 1, 1976 · N19153 · Substantial damage NTSB SEA76FYE50Accident · Minor injuriesClosedCessna 150 · Bellevue, WAJul 31, 1976 · N6837G · Destroyed NTSB SEA76FTA26Accident · Serious injuriesClosedCessna 150L · Miles City, MTJul 30, 1976 · N11547 · Destroyed NTSB LAX76FUD11Accident · No injuriesClosedCessna 150 · Compton, CAJul 27, 1976 · N10047 · Substantial damage NTSB NYC76FNA45Accident · No injuriesClosedCessna 150L · Freetown, MAJul 25, 1976 · N6754G · Substantial damage NTSB CHI76FEV54Accident · Minor injuriesClosedCessna 150L · Okawville, ILJul 24, 1976 · N10774 · Substantial damage NTSB NYC76FNC58Accident · No injuriesClosedCessna 150L · Westminster, VTJul 22, 1976 · N5237Q · Substantial damage NTSB DEN76FQA56Accident · Minor injuriesClosedCessna 150 · Tucumcari, NMJul 22, 1976 · N18155 · Substantial damage NTSB MIA76DKJ88Accident · No injuriesClosedCessna 150 · Hazel Green, ALJul 19, 1976 · N5297Q · Substantial damage NTSB OAK76DVD45Accident · No injuriesClosedCessna 150 · Novato, CAJul 17, 1976 · N5330Q · Substantial damage NTSB CHI76FEK22Accident · No injuriesClosedCessna 150L · Celina, OHJul 17, 1976 · N1357Q · Substantial damage NTSB SEA76FTI32Accident · No injuriesClosedCessna 150D · Lincoln, MTJul 14, 1976 · N19422 · Substantial damage NTSB LAX76FVA28Accident · No injuriesClosedCessna 150 · Fullerton, CAJul 14, 1976 · N11497 · Substantial damage

Back to Cessna 150L