Skip to content

NTSB investigations · 438

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 ('2071812') 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 ('2071812')
  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 ('2071812')
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 NYC67D0500Accident · Minor injuriesClosedCessna 150 · Princeton, NJFeb 22, 1967 · N6215T · Substantial damage NTSB MIA67D0411Accident · No injuriesClosedCessna 150 · Opa Locka, FLFeb 22, 1967 · N3991U · Substantial damage NTSB LAX67A0080Accident · No injuriesClosedCessna 150E · Santa Susana, CAFeb 19, 1967 · N4096U · Minor damage NTSB NYC67F0532Accident · No injuriesClosedCessna 150 · Holland, NYFeb 12, 1967 · N6202R · Substantial damage NTSB NYC67D0511Accident · No injuriesClosedCessna 150 · Colts Neck, NJFeb 12, 1967 · N3927U · Substantial damage NTSB OAK67D0215Accident · No injuriesClosedCessna 150 · Hayward, CAFeb 7, 1967 · N3035J · Substantial damage NTSB DEN67D0193Accident · No injuriesClosedCessna 150 · Woods Cross, UTJan 19, 1967 · N6141T · Substantial damage NTSB FTW67D0406Accident · No injuriesClosedCessna 150E · Duncan, OKDec 30, 1966 · N6298T · Substantial damage NTSB OAK67D0200Accident · No injuriesClosedCessna 150 · Ely, NVDec 27, 1966 · N3915U · Substantial damage NTSB NYC67D0474Accident · No injuriesClosedCessna 150 · Morristown, NJDec 23, 1966 · N3516J · Substantial damage NTSB OAK67D0170Accident · No injuriesClosedCessna 150E · Palo Alto, CANov 18, 1966 · N6138T · Substantial damage NTSB NYC67D0376Accident · No injuriesClosedCessna 150 · Burlington, CTNov 13, 1966 · N3992U · Substantial damage NTSB NYC67D0362Accident · No injuriesClosedCessna 150 · Lower Marlboro, MDNov 13, 1966 · N2553J · Substantial damage NTSB OAK67F0213Accident · No injuriesClosedCessna 150E · Concord, CANov 12, 1966 · N3050J · 2 aircraft · Substantial damage NTSB OAK67F0213Accident · No injuriesClosedCessna 150E · Concord, CANov 12, 1966 · N3550J · 2 aircraft · Substantial damage NTSB FTW67F0328Accident · No injuriesClosedCessna 150E · Mannsville, OKNov 8, 1966 · N6251T · Substantial damage NTSB FTW67F0265Accident · No injuriesClosedCessna 150 · Houston, TXOct 26, 1966 · N6211R · Substantial damage NTSB NYC67D0288Accident · No injuriesClosedCessna 150 · Croton-Hudson, NYOct 15, 1966 · N2562J · Substantial damage NTSB MIA67D0208Accident · No injuriesClosedCessna 150 · Davie, FLOct 13, 1966 · N4092U · Substantial damage NTSB LAX67D0166Accident · No injuriesClosedCessna 150 · Ocotillo Well, CAOct 8, 1966 · N6220T · Substantial damage NTSB CHI67F0334Accident · No injuriesClosedCessna 150 · Northbrook, ILOct 2, 1966 · N3514J · 2 aircraft · Substantial damage NTSB OAK67D0162Accident · No injuriesClosedCessna 150 · Las Vegas, NVSep 17, 1966 · N4042U · Substantial damage NTSB DEN67F0097Accident · Serious injuriesClosedCessna 150 · Uffalo, WYSep 11, 1966 · N3919U · Destroyed NTSB MIA67D0137Accident · Minor injuriesClosedCessna 150E · Cherokee, NCSep 5, 1966 · N3083J · Destroyed NTSB CHI67D0229Accident · No injuriesClosedCessna 150 · Northbrook, ILAug 23, 1966 · N6130T · 2 aircraft · Substantial damage NTSB MKC67A0011Accident · 2 fatalClosedCessna 150E · Smithville, MOAug 14, 1966 · N6188T · Destroyed NTSB MKC67D0154Accident · No injuriesClosedCessna 150 · Davenport, IAAug 11, 1966 · N6292T · Substantial damage NTSB MKC67F0210Accident · No injuriesClosedCessna 150E · St Louis, MOAug 1, 1966 · N3584J · Substantial damage NTSB CHI67A0016Accident · 1 fatalClosedCessna 150 · Racine, WIJul 27, 1966 · N3005J · Destroyed NTSB LAX67F0030Accident · No injuriesClosedCessna 150 · Van Nuys, CAJul 24, 1966 · N6222R · Substantial damage NTSB MIA67D0387Accident · Minor injuriesClosedCessna 150 · Phil Campbell, ALJul 23, 1966 · N6211T · Substantial damage NTSB MIA67F0059Accident · No injuriesClosedCessna 150 · St Petersburg, FLJul 14, 1966 · N3578J · Substantial damage NTSB MIA67D0006Accident · No injuriesClosedCessna 150 · Boca Raton, FLJul 14, 1966 · N4002U · Substantial damage NTSB MIA67D0050Accident · No injuriesClosedCessna 150 · Homestead, FLJul 12, 1966 · N3973U · Substantial damage NTSB CHI67D0225Accident · No injuriesClosedCessna 150 · Cleveland, OHJul 8, 1966 · N3981U · Substantial damage NTSB MIA67A0001Accident · 2 fatalClosedCessna 150E · Dania, FLJul 4, 1966 · N2585J · Destroyed NTSB NYC67F0120Accident · No injuriesClosedCessna 150 · Atlantic City, NJJul 3, 1966 · N2583J · 2 aircraft · Substantial damage NTSB NYC67D0021Accident · No injuriesClosedCessna 150 · Collegeville, PAJun 23, 1966 · N6167T · Substantial damage NTSB MIA66D0078Accident · No injuriesClosedCessna 150 · Atlanta, GAJun 15, 1966 · N3972U · Substantial damage NTSB MIA66F0572Accident · No injuriesClosedCessna 150 · Statesville, NCJun 13, 1966 · N3996U · Substantial damage NTSB LAX66F0377Accident · No injuriesClosedCessna 150 · Santa Ana, CAMay 30, 1966 · N4027U · Substantial damage NTSB CHI66F0757Accident · No injuriesClosedCessna 150 · Lansing, MIMay 22, 1966 · N2506J · Substantial damage NTSB MKC66D0570Accident · No injuriesClosedCessna 150 · Gordon, NEMay 21, 1966 · N6124T · Substantial damage NTSB LAX67D0002Accident · No injuriesClosedCessna 150 · San Fernando, CAMay 20, 1966 · N6284T · Substantial damage NTSB MIA66F0548Accident · Serious injuriesClosedCessna 150 · Knoxville, TNMay 15, 1966 · N6088T · Destroyed NTSB MIA66A0131Accident · 1 fatalClosedCessna 150 · Lagrange, GAMay 13, 1966 · N3513J · Destroyed NTSB CHI67F0004Accident · Serious injuriesClosedCessna 150 · Streator, ILApr 26, 1966 · N3574J · Destroyed NTSB SEA66D0298Accident · No injuriesClosedCessna 150E · Mulino, ORApr 22, 1966 · N3012J · Substantial damage NTSB LAX66D0313Accident · No injuriesClosedCessna 150 · Santa Monica, CAApr 13, 1966 · N3572J · Substantial damage NTSB MKC66D0572Accident · No injuriesClosedCessna 150 · Bonner Sprng, KSApr 8, 1966 · N4008U · Substantial damage

Back to Cessna 150E