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 NYC75DHA03Accident · No injuriesClosedCessna 150 · Gilbertville, PAJul 14, 1974 · N18146 · Substantial damage NTSB NYC75DNA04Accident · Minor injuriesClosedCessna 150L · Stow, MAJul 13, 1974 · N11386 · Substantial damage NTSB LAX75DUJ10Accident · Minor injuriesClosedCessna 150 · Chandler, AZJul 13, 1974 · N11941 · Substantial damage NTSB CHI75DEC03Accident · No injuriesClosedCessna 150L · Onsted, MIJul 11, 1974 · N18022 · Substantial damage NTSB MIA75FKG03Accident · No injuriesClosedCessna 150L · Monroe, GAJul 10, 1974 · N7303G · Substantial damage NTSB MKC75DCA04Accident · No injuriesClosedCessna 150 · Chesterfield, MOJul 9, 1974 · N11952 · Substantial damage NTSB NYC75DHM01Accident · Serious injuriesClosedCessna 150 · Flanders, NJJul 7, 1974 · N5498Q · Minor damage NTSB LAX75FUJ04Accident · No injuriesClosedCessna 150 · Page, AZJul 7, 1974 · N10940 · Substantial damage NTSB FTW75DPA07Accident · No injuriesClosedCessna 150L · Addison, TXJul 7, 1974 · N6870G · Substantial damage NTSB MKC75FCA05Accident · Serious injuriesClosedCessna 150L · Cuba, MOJul 3, 1974 · N10781 · Substantial damage NTSB LAX75FUQ01Accident · No injuriesClosedCessna 150 · Van Nuys, CAJul 2, 1974 · N5427Q · Substantial damage NTSB DEN75FQA01Accident · No injuriesClosedCessna 150 · Albuquerque, NMJul 2, 1974 · N19150 · No damage NTSB IAD74FID42Accident · No injuriesClosedCessna 150L · Ashland, VAJun 30, 1974 · N10574 · Substantial damage NTSB IAD74AI071Accident · 2 fatalClosedCessna 150L · Fayetteville, NCJun 29, 1974 · N19266 · Substantial damage NTSB CHI74FEC52Accident · Minor injuriesClosedCessna 150 · Port Huron, MIJun 27, 1974 · N6608G · Destroyed NTSB IAD74DLJ48Accident · No injuriesClosedCessna 150 · Ft Bragg, NCJun 25, 1974 · N19293 · Substantial damage NTSB MIA74FKG87Accident · Minor injuriesClosedCessna 150 · Marietta, GAJun 22, 1974 · N10056 · Substantial damage NTSB ANC74FAA39Accident · No injuriesClosedCessna 150 · Fairbanks, AKJun 20, 1974 · N16036 · Substantial damage NTSB NYC74DHA32Accident · No injuriesClosedCessna 150 · Pattenburg, NJJun 10, 1974 · N11258 · Substantial damage NTSB MIA75DLD96Accident · No injuriesClosedCessna 150 · Rockledge, FLJun 10, 1974 · N19144 · Substantial damage NTSB CHI74DEE79Accident · No injuriesClosedCessna 150 · Frankfort, ILMay 27, 1974 · N6820G · Substantial damage NTSB MIA74DKG80Accident · No injuriesClosedCessna 150 · Cedartown, GAMay 24, 1974 · N18027 · Substantial damage NTSB OAK74DVG60Accident · No injuriesClosedCessna 150 · Franklin, CAMay 23, 1974 · N17215 · Substantial damage NTSB CHI74FE140Accident · No injuriesClosedCessna 150L · Galion, OHMay 23, 1974 · N11069 · Substantial damage NTSB MIA74DLA44Accident · No injuriesClosedCessna 150 · Lake City, FLMay 21, 1974 · N19067 · Substantial damage NTSB FTW74AF085Accident · 1 fatalClosedCessna 150L · Abita Springs, LAMay 21, 1974 · N10484 · Destroyed NTSB NYC74DHA31Accident · Minor injuriesClosedCessna 150 · Somerville, NJMay 20, 1974 · N1596Q · Substantial damage NTSB CHI74FEA39Accident · No injuriesClosedCessna 150L · Lebanon, INMay 20, 1974 · N10795 · Substantial damage NTSB OAK74DVA66Accident · No injuriesClosedCessna 150 · Modesto, CAMay 18, 1974 · N7505G · Substantial damage NTSB NYC74AN095Accident · 1 fatalClosedCessna 150 · Fulton, NYMay 18, 1974 · N11780 · Destroyed NTSB LAX74DUJ62Accident · No injuriesClosedCessna 150 · Tucson, AZMay 15, 1974 · N21928 · Substantial damage NTSB OAK74DVM27Accident · No injuriesClosedCessna 150 · Palo Alto, CAMay 14, 1974 · N11290 · Substantial damage NTSB LAX74FUM28Accident · No injuriesClosedCessna 150 · San Diego, CAMay 12, 1974 · N1742Q · Substantial damage NTSB MKC74AK065Accident · 1 fatalClosedCessna 150L · Kranzburg, SDMay 9, 1974 · N11949 · Destroyed NTSB OAK74FVD30Accident · Minor injuriesClosedCessna 150 · San Leandro, CAMay 8, 1974 · N16198 · Destroyed NTSB DEN74DTC33Accident · No injuriesClosedCessna 150L · Riverton, WYMay 6, 1974 · N10950 · Substantial damage NTSB OAK74FVG50Accident · Serious injuriesClosedCessna 150 · Henleyville, CAMay 5, 1974 · N5295Q · Destroyed NTSB OAK74FVA62Accident · No injuriesClosedCessna 150L · Fresno, CAMay 2, 1974 · N10531 · Substantial damage NTSB MIA74FKQ18Accident · Serious injuriesClosedCessna 150L · Hattiesburg, MSApr 28, 1974 · N1777Q · Destroyed NTSB IAD74FIG25Accident · Minor injuriesClosedCessna 150 · White Marsh, MDApr 26, 1974 · N6755G · Substantial damage NTSB NYC74FHD34Accident · Serious injuriesClosedCessna 150L · Pennsauken, NJApr 21, 1974 · N6831G · Destroyed NTSB NYC74FFA28Accident · Minor injuriesClosedCessna 150 · Duanesburg, NYApr 21, 1974 · N1536Q · Substantial damage NTSB DEN74DQG59Accident · No injuriesClosedCessna 150 · Tumcumcari, NMApr 20, 1974 · N1586Q · Substantial damage NTSB CHI74DEC38Accident · No injuriesClosedCessna 150 · Mason, MIApr 20, 1974 · N6561G · Substantial damage NTSB LAX74FUG50Accident · Serious injuriesClosedCessna 150L · La Verne, CAApr 19, 1974 · N18559 · Substantial damage NTSB CHI74DEM54Accident · No injuriesClosedCessna 150 · Lansing, MIApr 17, 1974 · N156KA · Substantial damage NTSB MKC74DCD26Accident · No injuriesClosedCessna 150 · Laporte City, IAApr 16, 1974 · N16166 · Substantial damage NTSB MKC74DCJ36Accident · No injuriesClosedCessna 150L · North Platte, NEApr 14, 1974 · N6943G · Substantial damage NTSB LAX74DVA55Accident · No injuriesClosedCessna 150 · Bakersfield, CAApr 13, 1974 · N10513 · 2 aircraft · Destroyed NTSB NYC74FGM23Accident · No injuriesClosedCessna 150L · Waynesburg, PAApr 12, 1974 · N1495Q · Substantial damage

Back to Cessna 150L