Skip to content

NTSB investigations · 489

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 ('2071802') 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 ('2071802')
  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 ('2071802')
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 CHI79FA081Accident · 2 fatalClosedCessna 150 · Porcupine, WISep 23, 1979 · N7853E · Destroyed NTSB OAK79DVD30Accident · No injuriesClosedCessna 150 · Gualala, CAJun 14, 1979 · N7714E · Substantial damage NTSB IAD79FKM14Accident · No injuriesClosedCessna 150 · Charlotte, NCMay 20, 1979 · N5665E · Substantial damage NTSB LAX79DUG19Accident · Minor injuriesClosedCessna 150 · Thermal, CAFeb 25, 1979 · N5807E · Substantial damage NTSB IAD79FID01Accident · No injuriesClosedCessna 150 · Blacksburg, VAOct 12, 1978 · N5709E · Substantial damage NTSB OAK78DXQ45Accident · Minor injuriesClosedCessna 150 · S.Lake Tahoe, CASep 2, 1978 · N8130S · Substantial damage NTSB MIA78FKG70Accident · No injuriesClosedCessna 150 · Savannah, GAAug 7, 1978 · N5699E · Substantial damage NTSB MKC78FA056Accident · 2 fatalClosedCessna 150 · Columbus, KSJul 19, 1978 · N18544 · Destroyed NTSB CHI78DEP46Accident · No injuriesClosedCessna 150 · Kewaunee, WIJul 19, 1978 · N116DH · Substantial damage NTSB FTW78FRG62Accident · No injuriesClosedCessna 150 · Sandia, TXJul 15, 1978 · N5585E · Substantial damage NTSB CHI78DER04Accident · No injuriesClosedCessna 150L · Grantsburg, WIApr 30, 1978 · N150L · Substantial damage NTSB OAK78FVG19Accident · 1 fatalClosedCessna 150 · Vacaville, CAFeb 12, 1978 · N6539T · Destroyed NTSB MIA78AF019Accident · 1 fatalClosedCessna 150 · Dauphin Island, ALDec 17, 1977 · N6589T · Destroyed NTSB MIA78DLA07Accident · Minor injuriesClosedCessna 150 · Whigham, GANov 25, 1977 · N6546T · Substantial damage NTSB IAD78FKW01Accident · Minor injuriesClosedCessna 150 · Spring Hill, TNOct 2, 1977 · N5848E · Destroyed NTSB CHI78FEE02Accident · No injuriesClosedCessna 150 · Kankakee, ILOct 2, 1977 · N6572T · Substantial damage NTSB CHI77FEP63Accident · Serious injuriesClosedCessna 150L · Winneconne, WISep 14, 1977 · N19257 · Substantial damage NTSB MIA77FA079Accident · 1 fatalClosedCessna 150 · Ft.Lauderdale, FLAug 13, 1977 · N8791M · Destroyed NTSB MIA77DLA45Accident · No injuriesClosedCessna 150 · Nashville, GAAug 6, 1977 · N6428T · Substantial damage NTSB FTW7MDQG39Accident · No injuriesClosedCessna 150 · Groom, TXJul 9, 1977 · N7880E · Substantial damage NTSB CHI77FEK23Accident · Minor injuriesClosedCessna 150 · Nelsonville, OHJul 1, 1977 · N13086 · Substantial damage NTSB OAK77FA034Accident · 3 fatalClosedCessna 150L · San Ramon, CAJun 2, 1977 · N5456Q · 2 aircraft · Destroyed NTSB NYC77FNE11Accident · Minor injuriesClosedCessna 150M · Danbury, CTMar 27, 1977 · N3686V · Substantial damage NTSB SEA77DYE10Accident · No injuriesClosedCessna 150 · Gardiner, WAMar 6, 1977 · N5911E · Substantial damage NTSB LAX77FUG33Accident · Minor injuriesClosedCessna 150L · Riverside, CAMar 4, 1977 · N234AF · Destroyed NTSB FTW77FA038Accident · 1 fatalClosedCessna 150 · Center, TXFeb 25, 1977 · N5669E · Destroyed NTSB OAK77DVA15Accident · No injuriesClosedCessna 150 · Oakhurst, CAJan 16, 1977 · N150SS · Substantial damage NTSB NYC77FA015Accident · 1 fatalClosedCessna 150L · Sherburne, VTNov 23, 1976 · N5376Q · Destroyed NTSB CHI77FEE05Accident · No injuriesClosedCessna 150 · Oak Lawn, ILNov 5, 1976 · N17022 · Substantial damage NTSB LAX77FA007Accident · 2 fatalClosedCessna 150 · Terminal Islnd, CANov 4, 1976 · N51139 · 2 aircraft · Substantial damage NTSB DEN76FTE89Accident · No injuriesClosedCessna 150 · Hanover, COAug 14, 1976 · N3087J · Substantial damage NTSB SEA76FYG63Accident · No injuriesClosedCessna 150 · Mead, WAJul 5, 1976 · N5962E · Substantial damage NTSB LAX76FUD13Accident · No injuriesClosedCessna 150 · Van Nuys, CAJun 20, 1976 · N5804E · Substantial damage NTSB LAX76FUQ37Accident · No injuriesClosedCessna 150J · Van Nuys, CAApr 30, 1976 · N51283 · Substantial damage NTSB SEA76FTA19Accident · Serious injuriesClosedCessna 150 · Shawmut, MTApr 2, 1976 · N7836E · Destroyed NTSB FTW76FRA28Accident · Minor injuriesClosedCessna 150L · Pearland, TXApr 1, 1976 · N5306Q · Substantial damage NTSB FTW76FPD34Accident · No injuriesClosedCessna 150 · Arlington, TXMar 29, 1976 · N5779E · Substantial damage NTSB SEA76DYC29Accident · Serious injuriesClosedCessna 150H · Pacific City, ORFeb 7, 1976 · N22906 · Substantial damage NTSB MKC76FCG40Accident · Minor injuriesClosedCessna 150 · Lyndon, KSDec 20, 1975 · N7789E · Substantial damage NTSB SEA76DYC25Accident · No injuriesClosedCessna 150 · Vancouver, WANov 25, 1975 · N7719E · Substantial damage NTSB FTW76AF045Accident · 1 fatalClosedCessna 150F · Crowville, LANov 15, 1975 · N8607S · Destroyed NTSB MIA76FET19Accident · No injuriesClosedCessna 150 · Lake Village, INOct 30, 1975 · N45DB · Substantial damage NTSB MIA76AM033Accident · 1 fatalClosedCessna 150M · Hawthorne, FLOct 19, 1975 · N66406 · Destroyed NTSB SEA76FYC19Accident · No injuriesClosedCessna 150F · Portland, ORSep 11, 1975 · N8352G · Substantial damage NTSB OAK76DVD09Accident · Minor injuriesClosedCessna 150 · Whitethorn, CAAug 31, 1975 · N5210Q · Substantial damage NTSB IAD76DKM08Accident · No injuriesClosedCessna 150 · Yadkinville, NCJul 30, 1975 · N6548T · Substantial damage NTSB MIA75DKT87Accident · Minor injuriesClosedCessna 150 · Atlantic Ocean (Atlantic Ocean)Jun 24, 1975 · N2926V · Destroyed NTSB FTW75DPA28Accident · No injuriesClosedCessna 150 · Sulphur Spring, TXMay 18, 1975 · N5758E · Substantial damage NTSB IAD75DLJ26Accident · No injuriesClosedCessna 150 · Kitty Hawk, NCMay 6, 1975 · N10476 · Substantial damage NTSB NYC75FHD42Accident · Minor injuriesClosedCessna 150L · Toughkenamon, PAApr 23, 1975 · N5387Q · Destroyed

Back to Cessna 150