Skip to content

NTSB investigations · 1,193

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 ('2071816') 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 ('2071816')
  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 ('2071816')
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 FTW77DPG44Accident · No injuriesClosedCessna 150G · Arkadelphia, ARJun 11, 1977 · N6256S · Substantial damage NTSB OAK77DVG35Accident · No injuriesClosedCessna 150 · Dorris, CAMay 22, 1977 · N3364J · Substantial damage NTSB DEN77FTM14Accident · No injuriesClosedCessna 150G · E.Carbon City, UTApr 29, 1977 · N2936J · Substantial damage NTSB LAX77FUM18Accident · No injuriesClosedCessna 150 · Alpine, CAFeb 21, 1977 · N733JG · Substantial damage NTSB NYC77FGT05Accident · No injuriesClosedCessna 150 · Philipsburg, PADec 25, 1976 · N3788J · Destroyed NTSB FTW77DPG14Accident · No injuriesClosedCessna 150 · El Dorado, ARDec 23, 1976 · N8430J · Substantial damage NTSB FTW77DRG21Accident · Minor injuriesClosedCessna 150 · Mason, TXDec 22, 1976 · N4808X · Substantial damage NTSB OAK77FA008Accident · 2 fatalClosedCessna 150G · Escalon, CADec 19, 1976 · N2630J · Destroyed NTSB MKC77DTG01Accident · No injuriesClosedCessna 150 · Keene, NDDec 18, 1976 · N8563J · Substantial damage NTSB CHI77FEX06Accident · 1 fatalClosedCessna 150G · Patriot, INDec 15, 1976 · N2879S · Destroyed NTSB MIA77DKJ06Accident · Minor injuriesClosedCessna 150 · Eufaula, ALNov 26, 1976 · N8363J · Substantial damage NTSB SEA77DYA05Accident · Minor injuriesClosedCessna 150 · Blackfoot, IDNov 6, 1976 · N4047J · Substantial damage NTSB MIA77FLD11Accident · No injuriesClosedCessna 150G · Riverview, FLNov 3, 1976 · N3209J · Substantial damage NTSB DEN77FQA01Accident · No injuriesClosedCessna 150 · Valencia, NMOct 5, 1976 · N3643J · Substantial damage NTSB ANC76AA130Accident · 3 fatalClosedCessna 150 · Wrangell, AKSep 11, 1976 · N4710X · Destroyed NTSB OAK76DVD56Accident · Minor injuriesClosedCessna 150 · Concord, CAAug 27, 1976 · N4085J · Destroyed NTSB CHI76FEV60Accident · Minor injuriesClosedCessna 150G · Pekin, ILAug 22, 1976 · N6342S · Substantial damage NTSB MIA76DLA58Accident · No injuriesClosedCessna 150 · Pensacola, FLJul 25, 1976 · N8402J · Destroyed NTSB FTW76AF108Accident · 1 fatalClosedCessna 150G · Aubrey, TXJul 12, 1976 · N4736X · Destroyed NTSB MKC76DCQ64Accident · No injuriesClosedCessna 150G · Oxford, KSJul 5, 1976 · N3221J · Substantial damage NTSB DEN76DKG80Accident · Minor injuriesClosedCessna 150 · Statesboro, GAJun 29, 1976 · N2462J · Substantial damage NTSB NYC76DNA40Accident · Minor injuriesClosedCessna 150 · Shirley, MAJun 27, 1976 · N3883J · Substantial damage NTSB IAD76DLQ28Accident · No injuriesClosedCessna 150 · Cynthiana, KYJun 26, 1976 · N8621J · 2 aircraft · Minor damage NTSB OAK76DXQ51Accident · No injuriesClosedCessna 150 · Reno, NVJun 20, 1976 · N3078S · Substantial damage NTSB LAX76FUA25Accident · No injuriesClosedCessna 150 · Fullerton, CAMay 25, 1976 · N744JG · Substantial damage NTSB CHI76DEP30Accident · Minor injuriesClosedCessna 150 · Albany, WIMay 9, 1976 · N2931S · Substantial damage NTSB NYC76DNC38Accident · No injuriesClosedCessna 150 · Lincoln, MEApr 6, 1976 · N3254J · Substantial damage NTSB MKC76DCG68Accident · No injuriesClosedCessna 150 · Garnett, KSApr 3, 1976 · N3658J · Substantial damage NTSB OAK76AP046Accident · 2 fatalClosedCessna 150G · Salinas, CAMar 31, 1976 · N2767S · Destroyed NTSB NYC76FNE19Accident · No injuriesClosedCessna 150 · Worcester, MAMar 25, 1976 · N8353J · Substantial damage NTSB CHI76FEC28Accident · No injuriesClosedCessna 150G · Petersburg, MIFeb 20, 1976 · N3412J · Substantial damage NTSB MKC76FCD27Accident · Minor injuriesClosedCessna 150 · Davenport, IAFeb 17, 1976 · N3448J · Destroyed NTSB LAX76AL057Accident · 1 fatalClosedCessna 150G · Flagstaff, AZFeb 17, 1976 · N3474J · Destroyed NTSB FTW76DPD30Accident · No injuriesClosedCessna 150 · Mineral Wells, TXFeb 16, 1976 · N3403J · Substantial damage NTSB NYC76DFJ16Accident · No injuriesClosedCessna 150 · West Monroe, NYFeb 12, 1976 · N2985S · Substantial damage NTSB FTW76DQD12Accident · Minor injuriesClosedCessna 150 · Coyanosa, TXFeb 10, 1976 · N2816S · Substantial damage NTSB NYC76AN073Accident · 2 fatalClosedCessna 150 · Bridgeport, CTFeb 4, 1976 · N248Q · Destroyed NTSB NYC76FFA26Accident · No injuriesClosedCessna 150G · Cadyville, NYJan 21, 1976 · N3274J · Substantial damage NTSB SEA76FYG29Accident · Serious injuriesClosedCessna 150 · Spokane, WAJan 19, 1976 · N3423J · Substantial damage NTSB DEN76DTE47Accident · No injuriesClosedCessna 150 · Craig, COJan 4, 1976 · N2956J · Substantial damage NTSB FTW76FPA13Accident · Minor injuriesClosedCessna 150 · Rice, TXDec 26, 1975 · N8393J · Substantial damage NTSB MIA76RM050Accident · 1 fatalClosedCessna 150G · Nassau Np, Burkina FasoDec 13, 1975 · N4836X · Destroyed NTSB CHI76FER05Accident · No injuriesClosedCessna 150G · Rice Lake, WINov 15, 1975 · N3940J · Substantial damage NTSB MKC76FER38Accident · Serious injuriesClosedCessna 150G · Intl Falls, MNNov 13, 1975 · N3314J · Substantial damage NTSB OAK76FVA27Accident · Minor injuriesClosedCessna 150 · Madera, CANov 11, 1975 · N2915S · Substantial damage NTSB CHI76DEM20Accident · No injuriesClosedCessna 150G · Mikado, MINov 5, 1975 · N3961J · Substantial damage NTSB NYC76FHJ08Accident · No injuriesClosedCessna 150G · East Moriches, NYNov 2, 1975 · N3257J · Substantial damage NTSB IAD76FIJ06Accident · No injuriesClosedCessna 150G · Leading Creek, WVOct 12, 1975 · N4680X · Destroyed NTSB MKC76FCJ15Accident · No injuriesClosedCessna 150 · Wayne, NEOct 10, 1975 · N3244X · Substantial damage NTSB NYC76DFA15Accident · No injuriesClosedCessna 150 · Plattsburgh, NYSep 20, 1975 · N3274J · Substantial damage

Back to Cessna 150G