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 LAX74FUQ32Accident · No injuriesClosedCessna 150 · Snta Susana, CAApr 7, 1974 · N11469 · Substantial damage NTSB MIA74FLD78Accident · No injuriesClosedCessna 150 · Kissimmee, FLApr 3, 1974 · N1562Q · Substantial damage NTSB IAD74DLJ36Accident · No injuriesClosedCessna 150 · Whiteville, NCApr 3, 1974 · N19595 · Substantial damage NTSB NYC74FHM23Accident · No injuriesClosedCessna 150 · Teterboro, NJMar 31, 1974 · N10070 · Substantial damage NTSB LAX74DUJ50Accident · No injuriesClosedCessna 150 · Phoenix, AZMar 30, 1974 · N18670 · Substantial damage NTSB LAX74DUG45Accident · Minor injuriesClosedCessna 150 · Palm Sprngs, CAMar 30, 1974 · N16028 · Substantial damage NTSB MIA74FKG65Accident · Serious injuriesClosedCessna 150L · Perry, GAMar 27, 1974 · N6603G · Substantial damage NTSB SEA74FYE41Accident · No injuriesClosedCessna 150 · Redmond, WAMar 20, 1974 · N5469Q · Substantial damage NTSB CHI74DEG19Accident · No injuriesClosedCessna 150 · Springfield, OHMar 17, 1974 · N18202 · Substantial damage NTSB CHI74DEE63Accident · No injuriesClosedCessna 150 · Rochelle, ILMar 16, 1974 · N10488 · Substantial damage NTSB FTW74AF067Accident · 1 fatalClosedCessna 150L · Houston, TXMar 15, 1974 · N10009 · Destroyed NTSB OAK74DVW14Accident · No injuriesClosedCessna 150L · Lone Pine, CAMar 14, 1974 · N21999 · Substantial damage NTSB LAX74FUQ36Accident · Serious injuriesClosedCessna 150L · Snta Brbara, CAMar 14, 1974 · N6685G · Substantial damage NTSB CHI74FEV40Accident · No injuriesClosedCessna 150 · Monticello, ILMar 13, 1974 · N6690G · Substantial damage NTSB LAX74AL061Accident · 2 fatalClosedCessna 150L · Santa Ana, CAMar 12, 1974 · N1564Q · Destroyed NTSB IAD74DKM43Accident · No injuriesClosedCessna 150 · Gastonia, NCMar 3, 1974 · N17045 · Substantial damage NTSB MIA74AM075Accident · 2 fatalClosedCessna 150L · Bessemer, ALFeb 26, 1974 · N1355Q · Destroyed NTSB FTW74AF063Accident · 2 fatalClosedCessna 150 · Tyler, TXFeb 23, 1974 · N18563 · 2 aircraft · Destroyed NTSB MIA74DLD65Accident · Minor injuriesClosedCessna 150 · Zephyrhills, FLFeb 16, 1974 · N10688 · Substantial damage NTSB FTW74FRA30Accident · No injuriesClosedCessna 150L · Houston, TXFeb 14, 1974 · N17027 · Substantial damage NTSB CHI74FEI29Accident · No injuriesClosedCessna 150L · Carrollton, OHFeb 14, 1974 · N11148 · Substantial damage NTSB NYC74FGM17Accident · No injuriesClosedCessna 150L · Evans City, PAFeb 10, 1974 · N1399Q · Substantial damage NTSB CHI74DEI28Accident · No injuriesClosedCessna 150L · Chagrin Fall, OHFeb 9, 1974 · N11358 · Substantial damage NTSB IAD74AI041Accident · 1 fatalClosedCessna 150L · Samos, VAFeb 4, 1974 · N6927G · Destroyed NTSB FTW74FPD34Accident · 1 fatalClosedCessna 150L · Sanger, TXFeb 3, 1974 · N18216 · Destroyed NTSB MKC74FCA22Accident · No injuriesClosedCessna 150L · St Charles, MOJan 29, 1974 · N10681 · Substantial damage NTSB IAD74DHD26Accident · Minor injuriesClosedCessna 150 · Cheswold, DEJan 22, 1974 · N18140 · Substantial damage NTSB NYC74FNC36Accident · No injuriesClosedCessna 150 · Eliot, MEJan 20, 1974 · N18585 · Substantial damage NTSB CHI74FEC28Accident · No injuriesClosedCessna 150L · Mason, MIJan 19, 1974 · N16080 · Substantial damage NTSB MKC74DCG19Accident · No injuriesClosedCessna 150 · Lawrence, KSJan 16, 1974 · N6095J · Substantial damage NTSB MIA74DLG19Accident · No injuriesClosedCessna 150 · Myrtle Beach, SCJan 14, 1974 · N6534G · Substantial damage NTSB CHI74DEV34Accident · No injuriesClosedCessna 150 · Pekin, ILJan 14, 1974 · N11570 · Substantial damage NTSB DEN74DTE47Accident · No injuriesClosedCessna 150 · Greeley, COJan 10, 1974 · N1396Q · Substantial damage NTSB MIA74FKT49Accident · No injuriesClosedCessna 150 · Ft Lauderdale, FLJan 8, 1974 · N19066 · 2 aircraft · Substantial damage NTSB CHI74FEK11Accident · No injuriesClosedCessna 150L · Marion, OHJan 4, 1974 · N19079 · Substantial damage NTSB CHI74DEI19Accident · No injuriesClosedCessna 150 · Toledo, OHJan 2, 1974 · N19362 · Substantial damage NTSB MIA74FKG48Accident · Minor injuriesClosedCessna 150L · Tifton, GADec 31, 1973 · N5389Q · Destroyed NTSB CHI74DEE41Accident · Minor injuriesClosedCessna 150 · Wheeling, ILDec 31, 1973 · N19277 · Substantial damage NTSB CHI74DEE45Accident · No injuriesClosedCessna 150 · Lansing, ILDec 30, 1973 · N19240 · Substantial damage NTSB MKC74AK034Accident · 1 fatalClosedCessna 150L · Turton, SDDec 23, 1973 · N7020G · Substantial damage NTSB OAK74DJY09Accident · 2 fatalClosedCessna 150 · Tagaytay City, RPDec 22, 1973 · N21963 · Destroyed NTSB CHI74DEE40Accident · No injuriesClosedCessna 150 · Rochelle, ILDec 20, 1973 · N10488 · Substantial damage NTSB MKC74DCG16Accident · No injuriesClosedCessna 150L · Pleasanton, KSDec 18, 1973 · N18640 · Substantial damage NTSB FTW74DPM13Accident · No injuriesClosedCessna 150 · Tulsa, OKDec 15, 1973 · N18124 · 2 aircraft · Destroyed NTSB DEN74AD031Accident · 1 fatalClosedCessna 150L · Cheyenne, WYDec 15, 1973 · N19583 · Destroyed NTSB MKC74DCJ20Accident · No injuriesClosedCessna 150 · Angora, NEDec 10, 1973 · N11183 · Substantial damage NTSB CHI74DEP24Accident · No injuriesClosedCessna 150 · Crivitz, WIDec 10, 1973 · N10772 · Substantial damage NTSB MIA74FKA07Accident · No injuriesClosedCessna 150 · Humacao, PRDec 9, 1973 · N1707Q · Substantial damage NTSB IAD74FIG16Accident · Serious injuriesClosedCessna 150 · Laurel, MDDec 4, 1973 · N19327 · Substantial damage NTSB NYC74FNA28Accident · No injuriesClosedCessna 150L · Lawrence, MADec 2, 1973 · N7529G · Substantial damage

Back to Cessna 150L