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 NYC67F0073Accident · No injuriesClosedCessna 150 · Scarboro, MEJul 17, 1966 · N6508T · Substantial damage NTSB FTW67D0093Accident · No injuriesClosedCessna 150 · Austin, TXJul 13, 1966 · N6421T · Substantial damage NTSB NYC67D0102Accident · No injuriesClosedCessna 150 · Gaithersburg, MDJul 12, 1966 · N7811E · Substantial damage NTSB FTW67D0084Accident · No injuriesClosedCessna 150 · Blue Mound, TXJul 5, 1966 · N7896E · Substantial damage NTSB SEA67F0084Accident · No injuriesClosedCessna 150 · Cottage Grove, ORJul 4, 1966 · N6604T · Substantial damage NTSB LAX67D0052Accident · No injuriesClosedCessna 150 · Acton, CAJun 27, 1966 · N5739E · Substantial damage NTSB FTW67D0044Accident · No injuriesClosedCessna 150 · Cordell, OKJun 26, 1966 · N7825E · Substantial damage NTSB CHI67D0063Accident · No injuriesClosedCessna 150 · Carmel, INJun 25, 1966 · N5535E · Substantial damage NTSB DEN67D0009Accident · No injuriesClosedCessna 150 · Meeker, COJun 23, 1966 · N5658E · Substantial damage NTSB SEA67D0014Accident · No injuriesClosedCessna 150 · Richland, WAJun 18, 1966 · N7794E · Substantial damage NTSB NYC67D0005Accident · No injuriesClosedCessna 150 · Neffsville, PAJun 8, 1966 · N8806S · Substantial damage NTSB OAK67D0072Accident · No injuriesClosedCessna 150 · Las Vegas, NVJun 5, 1966 · N5638E · Substantial damage NTSB CHI66A0092Accident · 1 fatalClosedCessna 150 · No.Jackson, OHMay 25, 1966 · N4143U · Destroyed NTSB SEA67D0050Accident · No injuriesClosedCessna 150 · Beaverton, ORMay 19, 1966 · N5611E · Substantial damage NTSB SEA67F0043Accident · No injuriesClosedCessna 150 · Chehalis, WAMay 17, 1966 · N5972E · Substantial damage NTSB FTW66F0657Accident · No injuriesClosedCessna 150 · Dallas, TXMay 4, 1966 · N7941E · Substantial damage NTSB MIA66F0529Accident · No injuriesClosedCessna 150 · Franklinton, NCMay 1, 1966 · N7784E · Destroyed NTSB LAX66F0319Accident · No injuriesClosedCessna 150 · Van Nuys, CAApr 29, 1966 · N6534T · Substantial damage NTSB LAX66D0297Accident · No injuriesClosedCessna 150 · Palm Springs, CAApr 8, 1966 · N6053T · Substantial damage NTSB LAX66F0288Accident · No injuriesClosedCessna 150 · Van Nuys, CAApr 2, 1966 · N6414T · Substantial damage NTSB OAK66A0042Accident · 1 fatalClosedCessna 150 · San Jose, CAMar 27, 1966 · N6423T · Destroyed NTSB OAK66F0245Accident · Minor injuriesClosedCessna 150 · Honolulu, HIMar 16, 1966 · N6473T · Substantial damage NTSB NYC66D0541Accident · No injuriesClosedCessna 150 · Whitesville, NJMar 16, 1966 · N5990E · Substantial damage NTSB NYC66A0100Accident · 2 fatalClosedCessna 150 · Waltham, MAMar 16, 1966 · N2063Z · Destroyed NTSB MKC66D0526Accident · No injuriesClosedCessna 150 · Hibbing, MNMar 14, 1966 · N5999T · Substantial damage NTSB DEN66F0721Accident · Serious injuriesClosedCessna 150 · Las Cruces, NMMar 14, 1966 · N6592T · Destroyed NTSB FTW66A0077Accident · 2 fatalClosedCessna 150 · Houston, TXMar 6, 1966 · N7927E · Destroyed NTSB DEN66D0301Accident · No injuriesClosedCessna 150 · Hotchkiss, COFeb 25, 1966 · N3074J · Substantial damage NTSB SEA66D0215Accident · No injuriesClosedCessna 150 · Council, IDFeb 20, 1966 · N5822E · Substantial damage NTSB NYC66F0508Accident · No injuriesClosedCessna 150 · New Cumberland, PAFeb 12, 1966 · N7842E · Substantial damage NTSB MIA66D0418Accident · Minor injuriesClosedCessna 150 · Homestead, FLFeb 2, 1966 · N5768E · Substantial damage NTSB OAK66F0192Accident · Minor injuriesClosedCessna 150 · Monterey, CAJan 22, 1966 · N6488T · Destroyed NTSB SEA66F0253Accident · Serious injuriesClosedCessna 150 · Seattle, WAJan 20, 1966 · N5718E · Substantial damage NTSB LAX66D0210Accident · No injuriesClosedCessna 150 · Santa Paula, CAJan 16, 1966 · N7774E · Substantial damage NTSB NYC66D0433Accident · No injuriesClosedCessna 150 · Ambler, PAJan 14, 1966 · N8425G · Substantial damage NTSB CHI66D0519Accident · No injuriesClosedCessna 150 · Russelville, KYJan 9, 1966 · N5986E · Substantial damage NTSB LAX66F0212Accident · No injuriesClosedCessna 150 · Long Beach, CAJan 1, 1966 · N2029Z · Substantial damage NTSB SEA66F0193Accident · No injuriesClosedCessna 150 · Ellensburg, WADec 30, 1965 · N7718E · Substantial damage NTSB FTW66D0437Accident · No injuriesClosedCessna 150 · Fayetteville, ARDec 29, 1965 · N6469T · Substantial damage NTSB FTW66F0438Accident · No injuriesClosedCessna 150 · Houston, TXDec 8, 1965 · N7860E · Substantial damage NTSB NYC66D0358Accident · No injuriesClosedCessna 150 · Falmouth, MANov 21, 1965 · N7728E · Substantial damage NTSB MKC66A0031Accident · 2 fatalClosedCessna 150 · Mitchell, SDNov 7, 1965 · N7956E · Destroyed NTSB DEN66D0139Accident · No injuriesClosedCessna 150 · Roswell, NMNov 3, 1965 · N7749E · Substantial damage NTSB NYC66F0289Accident · No injuriesClosedCessna 150 · West Chester, PAOct 16, 1965 · N5633E · Substantial damage NTSB NYC66D0304Accident · No injuriesClosedCessna 150 · Clinton, MDOct 13, 1965 · N5830E · Substantial damage NTSB NYC66F0267Accident · No injuriesClosedCessna 150 · Beverly, MASep 22, 1965 · N7884E · Substantial damage NTSB LAX66A0030Accident · 2 fatalClosedCessna 150 · Guatay, CASep 18, 1965 · N5867E · Destroyed NTSB MIA66A0032Accident · 2 fatalClosedCessna 150 · Resaca, GASep 16, 1965 · N7960E · Destroyed NTSB FTW66D0349Accident · No injuriesClosedCessna 150 · Portland, TXSep 14, 1965 · N5678E · Substantial damage NTSB MKC66F0251Accident · No injuriesClosedCessna 150 · Mound, MNSep 5, 1965 · N5862E · Substantial damage

Back to Cessna 150