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 OAK73DVM39Incident · No injuriesClosedCessna 150 · Moss Beach, CAJun 19, 1973 · N17147 · 2 aircraft · Minor damage NTSB MIA73AM110Accident · 1 fatalClosedCessna 150L · Key West, FLJun 15, 1973 · N19279 · Destroyed NTSB CHI73DEE65Accident · No injuriesClosedCessna 150 · Joliet, ILJun 9, 1973 · N6798G · Substantial damage NTSB FTW73FPD42Accident · Minor injuriesClosedCessna 150L · Saginaw, TXJun 8, 1973 · N6EB · Destroyed NTSB NYC74DFJ05Accident · No injuriesClosedCessna 150 · Dunkirk, NYJun 4, 1973 · N18004 · Substantial damage NTSB FTW73FPJ21Accident · No injuriesClosedCessna 150L · Yukon, OKMay 29, 1973 · N19200 · Substantial damage NTSB SEA73DYC31Accident · No injuriesClosedCessna 150 · Salem, ORMay 28, 1973 · N21986 · Substantial damage NTSB CHI73DEE63Accident · Minor injuriesClosedCessna 150L · Frankfort, ILMay 25, 1973 · N18534 · Substantial damage NTSB MIA73DKJ59Accident · Serious injuriesClosedCessna 150 · Talledega, ALMay 15, 1973 · N6604G · Destroyed NTSB FTW73DPJ18Accident · Minor injuriesClosedCessna 150L · Enid, OKMay 15, 1973 · N5241Q · Destroyed NTSB FTW73FRD24Accident · Minor injuriesClosedCessna 150L · Baton Rouge, LAMay 14, 1973 · N18043 · Substantial damage NTSB NYC73FNE33Accident · No injuriesClosedCessna 150L · Northamton, MAMay 13, 1973 · N18678 · Substantial damage NTSB OAK73DVA60Accident · No injuriesClosedCessna 150 · Los Banos, CAMay 6, 1973 · N6669G · Substantial damage NTSB FTW73DRA26Accident · No injuriesClosedCessna 150L · Friendswood, TXMay 4, 1973 · N6824G · Substantial damage NTSB CHI73DEP42Accident · No injuriesClosedCessna 150 · Sheboygan, WIMay 3, 1973 · N18690 · Substantial damage NTSB MIA73DKG73Accident · No injuriesClosedCessna 150L · Stockbridge, GAApr 30, 1973 · N18209 · Substantial damage NTSB OAK73FXQ28Accident · Minor injuriesClosedCessna 150 · Portola, CAApr 26, 1973 · N19346 · Substantial damage NTSB MIA73FKT87Accident · Serious injuriesClosedCessna 150L · Pompano Beach, FLApr 26, 1973 · N6939G · Substantial damage NTSB NYC73DHD36Accident · No injuriesClosedCessna 150 · Williamstown, NJApr 21, 1973 · N19344 · Substantial damage NTSB OAK73FJA17Accident · 2 fatalClosedCessna 150L · Waipahu, HIApr 19, 1973 · N1216Q · Destroyed NTSB MIA73FKT83Accident · No injuriesClosedCessna 150L · Dania, FLApr 18, 1973 · N6773G · Substantial damage NTSB MKC73AK062Accident · 2 fatalClosedCessna 150L · Medinan, NDApr 16, 1973 · N5243Q · Destroyed NTSB LAX73FUG48Accident · No injuriesClosedCessna 150L · Corona, CAApr 10, 1973 · N1748Q · Substantial damage NTSB IAD73FKM32Accident · Serious injuriesClosedCessna 150 · Advance, NCApr 9, 1973 · N5471Q · No damage NTSB LAX73DUJ77Accident · Minor injuriesClosedCessna 150 · Glendale, AZApr 7, 1973 · N6568G · Substantial damage NTSB MKC73FCJ33Accident · No injuriesClosedCessna 150L · Fort Calhoun, NEApr 4, 1973 · N16098 · Substantial damage NTSB ANC73DAG79Accident · No injuriesClosedCessna 150 · Anchorage, AKApr 2, 1973 · N6769G · Substantial damage NTSB MKC73DCG34Accident · No injuriesClosedCessna 150 · Point Lookout, MOMar 22, 1973 · N1599Q · Substantial damage NTSB LAX73FUA35Accident · No injuriesClosedCessna 150L · Carson, CAMar 22, 1973 · N17004 · Substantial damage NTSB CHI73DEC25Accident · No injuriesClosedCessna 150 · Flint, MIMar 21, 1973 · N1642Q · Substantial damage NTSB IAD73DKM25Accident · Minor injuriesClosedCessna 150 · Advance, NCMar 14, 1973 · N6624G · Substantial damage NTSB MIA73FKT72Accident · No injuriesClosedCessna 150L · Miami, FLMar 10, 1973 · N16035 · Substantial damage NTSB OAK73DVG51Accident · No injuriesClosedCessna 150 · Red Bluff, CAMar 9, 1973 · N1439Q · Substantial damage NTSB SEA73FYI12Accident · No injuriesClosedCessna 150 · Roseburg, ORMar 6, 1973 · N6561G · Substantial damage NTSB NYC73AN119Accident · 1 fatalClosedCessna 150 · York, NYMar 2, 1973 · N18521 · Destroyed NTSB NYC73FHM22Accident · No injuriesClosedCessna 150L · Lincoln Park, NJMar 1, 1973 · N18562 · Substantial damage NTSB NYC73FGT08Accident · Minor injuriesClosedCessna 150L · Halifax, PAFeb 23, 1973 · N6591G · Substantial damage NTSB LAX73FUQ21Accident · Minor injuriesClosedCessna 150 · Pacoima, CAFeb 20, 1973 · N19084 · Substantial damage NTSB LAX73DUM19Accident · Minor injuriesClosedCessna 150L · Brawley, CAFeb 18, 1973 · N19116 · Substantial damage NTSB SEA73FYE25Accident · No injuriesClosedCessna 150L · Renton, WAFeb 17, 1973 · N6519G · Substantial damage NTSB MKC73DCD51Accident · No injuriesClosedCessna 150 · Waterloo, IAFeb 17, 1973 · N1264Q · Substantial damage NTSB NYC73FHD26Accident · No injuriesClosedCessna 150L · Williamstown, NJFeb 14, 1973 · N18210 · Substantial damage NTSB NYC73FIA10Accident · No injuriesClosedCessna 150L · Manassas, VAFeb 12, 1973 · N1308Q · Substantial damage NTSB CHI73AC068Accident · 2 fatalClosedCessna 150L · Morris, ILFeb 4, 1973 · N6974G · Destroyed NTSB NYC73AN108Accident · 1 fatalClosedCessna 150 · Taunton, MAFeb 3, 1973 · N5499Q · Destroyed NTSB FTW73AF040Accident · No injuriesClosedCessna 150L · Beaumont, TXFeb 3, 1973 · N1268Q · 2 aircraft · Substantial damage NTSB FTW73AF040Accident · No injuriesClosedCessna 150L · Beaumont, TXFeb 3, 1973 · N18741 · 2 aircraft · Substantial damage NTSB NYC73FHD24Accident · Minor injuriesClosedCessna 150L · Up.Phoenixvile, PAJan 31, 1973 · N6759G · Substantial damage NTSB OAK73FJZ03Accident · Serious injuriesClosedCessna 150 · Kashima Isl, JAJan 29, 1973 · N6772G · Substantial damage NTSB OAK73DVG43Accident · No injuriesClosedCessna 150 · Pope Valley, CAJan 27, 1973 · N6744G · Substantial damage

Back to Cessna 150L