Skip to content

NTSB investigations · 1,653

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 ('2071814') 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 ('2071814')
  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 ('2071814')
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 FTW67D0072Accident · No injuriesClosedCessna 150 · Ardmore, OKJul 14, 1966 · N8191S · Substantial damage NTSB NYC67D0167Accident · No injuriesClosedCessna 150 · New City, NYJul 13, 1966 · N8128F · Substantial damage NTSB CHI67D0104Accident · No injuriesClosedCessna 150 · Indianapolis, INJul 10, 1966 · N6518F · Substantial damage NTSB NYC67D0097Accident · No injuriesClosedCessna 150 · Danvers, MAJul 9, 1966 · N6562F · Substantial damage NTSB OAK67D0031Accident · No injuriesClosedCessna 150 · Concord, CAJul 8, 1966 · N6849F · Substantial damage NTSB MKC67D0064Accident · No injuriesClosedCessna 150 · Ft.Len.Wood, MOJul 5, 1966 · N8769G · Substantial damage NTSB MIA67F0011Accident · No injuriesClosedCessna 150 · Clinton, NCJul 5, 1966 · N7030F · Substantial damage NTSB FTW67D0055Accident · No injuriesClosedCessna 150 · Waurtka, OKJul 5, 1966 · N8399G · Substantial damage NTSB MIA67D0130Accident · No injuriesClosedCessna 150 · Johns Island, SCJul 4, 1966 · N8483G · Substantial damage NTSB DEN67D0033Accident · No injuriesClosedCessna 150 · Elizabeth, COJul 3, 1966 · N8784S · Substantial damage NTSB NYC67F0055Accident · No injuriesClosedCessna 150 · Richmond, VAJul 2, 1966 · N8672G · Substantial damage NTSB OAK67D0131Accident · No injuriesClosedCessna 150 · San Carlos, CAJun 28, 1966 · N7918F · Substantial damage NTSB SEA67F0052Accident · No injuriesClosedCessna 150 · Leavenworth, WAJun 26, 1966 · N8801S · Substantial damage NTSB FTW67F0025Accident · Serious injuriesClosedCessna 150 · Bogalusa, LAJun 25, 1966 · N8036S · Substantial damage NTSB CHI67F0099Accident · No injuriesClosedCessna 150 · East St.Louis, ILJun 23, 1966 · N7973F · Substantial damage NTSB CHI67D0211Accident · No injuriesClosedCessna 150 · Northbrook, ILJun 22, 1966 · N8022S · Substantial damage NTSB MIA67F0125Accident · No injuriesClosedCessna 150F · Cross City, FLJun 19, 1966 · N6719F · Substantial damage NTSB MIA66D0611Accident · No injuriesClosedCessna 150 · Palmdale, FLJun 19, 1966 · N6444F · Substantial damage NTSB NYC67D0065Accident · No injuriesClosedCessna 150 · Frederick, MDJun 18, 1966 · N8052F · Substantial damage NTSB MKC67F0127Accident · No injuriesClosedCessna 150 · Mandan, NDJun 18, 1966 · N6251R · Substantial damage NTSB CHI67F0042Accident · No injuriesClosedCessna 150F · E St Louis, ILJun 14, 1966 · N7944F · Substantial damage NTSB NYC67D0018Accident · No injuriesClosedCessna 150 · N. Andover, MAJun 12, 1966 · N3590L · Substantial damage NTSB MKC67F0070Accident · No injuriesClosedCessna 150 · Creve Coeur, MOJun 12, 1966 · N6959F · Substantial damage NTSB FTW67F0014Accident · No injuriesClosedCessna 150 · Port Aransas, TXJun 12, 1966 · N8696S · Substantial damage NTSB SEA67D0048Accident · No injuriesClosedCessna 150 · Renton, WAJun 11, 1966 · N7807F · Substantial damage NTSB NYC67D0006Accident · No injuriesClosedCessna 150 · Huntingdon, PAJun 5, 1966 · N6806F · Substantial damage NTSB DEN67D0002Accident · No injuriesClosedCessna 150 · Provo, UTJun 5, 1966 · N8654S · Substantial damage NTSB NYC67D0012Accident · Minor injuriesClosedCessna 150 · New City, NYJun 4, 1966 · N6592F · Substantial damage NTSB LAX66F0354Accident · No injuriesClosedCessna 150F · Chino, CAJun 1, 1966 · N8914S · Substantial damage NTSB NYC66A0138Accident · 1 fatalClosedCessna 150F · Fairfield, NJMay 31, 1966 · N8782S · Destroyed NTSB MIA66F0599Accident · No injuriesClosedCessna 150 · Opa Locka, FLMay 28, 1966 · N8267S · Substantial damage NTSB CHI66D0787Accident · No injuriesClosedCessna 150 · Marion, OHMay 27, 1966 · N8952S · Substantial damage NTSB SEA67F0056Accident · No injuriesClosedCessna 150 · Portland, ORMay 26, 1966 · N3576L · Substantial damage NTSB MIA66A0137Accident · 2 fatalClosedCessna 150 · Lake City, FLMay 25, 1966 · N8701G · Destroyed NTSB NYC66F0712Accident · No injuriesClosedCessna 150 · Friendly, MDMay 24, 1966 · N8759S · Substantial damage NTSB FTW66F0677Accident · Minor injuriesClosedCessna 150F · Greenville, TXMay 21, 1966 · N8323G · Substantial damage NTSB MIA66F0594Accident · No injuriesClosedCessna 150F · Crescent Beach, SCMay 20, 1966 · N8479G · Substantial damage NTSB CHI66F0735Accident · No injuriesClosedCessna 150 · Milwauke, WIMay 19, 1966 · N6765F · Substantial damage NTSB LAX66A0089Accident · No injuriesClosedCessna 150 · Santa Ynez, CAMay 18, 1966 · N8076S · 2 aircraft · Substantial damage NTSB CHI66D0736Accident · No injuriesClosedCessna 150F · Springfield, OHMay 18, 1966 · N8277S · Substantial damage NTSB MKC66F0562Accident · No injuriesClosedCessna 150 · Kansas City, KSMay 12, 1966 · N6725F · Substantial damage NTSB MIA66D0579Accident · No injuriesClosedCessna 150 · Opa Locka, FLMay 12, 1966 · N8380G · Substantial damage NTSB MIA66D0540Accident · No injuriesClosedCessna 150 · Chamblee, GAMay 9, 1966 · N8821S · Substantial damage NTSB CHI66D0771Accident · No injuriesClosedCessna 150 · East St.Louis, ILMay 8, 1966 · N8391G · Substantial damage NTSB NYC66F0633Accident · No injuriesClosedCessna 150 · Gaithersburg, MDMay 7, 1966 · N8612S · Substantial damage NTSB MKC66D0568Accident · No injuriesClosedCessna 150F · Cape Girardeau, MOMay 7, 1966 · N8809S · Substantial damage NTSB CHI66F0719Accident · No injuriesClosedCessna 150F · Rockford, ILMay 7, 1966 · N8331G · Substantial damage NTSB OAK66F0290Accident · No injuriesClosedCessna 150 · Fresno, CAMay 6, 1966 · N8093S · Substantial damage NTSB MIA66D0551Accident · No injuriesClosedCessna 150F · Miami, FLMay 6, 1966 · N8474G · Substantial damage NTSB LAX66A0082Accident · 1 fatalClosedCessna 150F · Santa Ana, CAMay 4, 1966 · N8258S · Destroyed

Back to Cessna 150F