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 DIA68D0080Accident · No injuriesClosedCessna 150 · New Kent, VAOct 3, 1967 · N6287S · Substantial damage NTSB DIA68A0014Accident · 2 fatalClosedCessna 150G · Fincastle, VAOct 2, 1967 · N8665J · Destroyed NTSB OAK68D0140Accident · No injuriesClosedCessna 150 · Lund, NVSep 30, 1967 · N6236S · Substantial damage NTSB MKC68D0272Accident · No injuriesClosedCessna 150G · Worthington, MNSep 28, 1967 · N3365J · Substantial damage NTSB NYC68D0225Accident · Minor injuriesClosedCessna 150 · Pine Plains, NYSep 27, 1967 · N2475J · Substantial damage NTSB OAK68D0200Accident · Minor injuriesClosedCessna 150G · Santa Rosa, CASep 25, 1967 · N3243J · Substantial damage NTSB NYC68D0201Accident · No injuriesClosedCessna 150 · Loganton, PASep 24, 1967 · N2928S · Substantial damage NTSB FTW68F0239Accident · Minor injuriesClosedCessna 150 · Gainesville, TXSep 23, 1967 · N2778S · Substantial damage NTSB MIA68F0144Accident · No injuriesClosedCessna 150G · Centerville, TNSep 16, 1967 · N8349J · Substantial damage NTSB MIA68D0181Accident · No injuriesClosedCessna 150 · Batesville, MSSep 16, 1967 · N2744S · Substantial damage NTSB LAX68F0170Accident · No injuriesClosedCessna 150G · Torrance, CASep 16, 1967 · N8346J · Substantial damage NTSB MIA68F0216Accident · Serious injuriesClosedCessna 150 · Hazel Green, ALSep 13, 1967 · N2206J · Substantial damage NTSB MKC68D0168Accident · No injuriesClosedCessna 150 · Emporia, KSSep 4, 1967 · N3854J · Substantial damage NTSB NYC68F0174Accident · No injuriesClosedCessna 150G · Milford, DESep 1, 1967 · N2992J · Substantial damage NTSB SEA68D0179Accident · No injuriesClosedCessna 150G · Wasco, ORAug 27, 1967 · N3292J · Substantial damage NTSB SEA68D0171Accident · No injuriesClosedCessna 150G · North Bend, ORAug 23, 1967 · N4024J · Substantial damage NTSB CHI68F0284Accident · No injuriesClosedCessna 150 · Warren, ILAug 23, 1967 · N2985J · Substantial damage NTSB MKC68D0169Accident · No injuriesClosedCessna 150 · Rosehill, KSAug 22, 1967 · N8568J · Substantial damage NTSB DIA68D0063Accident · No injuriesClosedCessna 150 · Forest Hill, WVAug 21, 1967 · N2668J · Substantial damage NTSB DEN68D0076Accident · No injuriesClosedCessna 150 · Sedalia, COAug 20, 1967 · N3285J · Substantial damage NTSB NYC68D0116Accident · No injuriesClosedCessna 150 · Kerhonkson, NYAug 17, 1967 · N3108J · Substantial damage NTSB OAK68F0061Accident · No injuriesClosedCessna 150 · Davis, CAAug 8, 1967 · N3315J · Substantial damage NTSB CHI68D0315Accident · No injuriesClosedCessna 150 · Freeport, ILAug 6, 1967 · N3286J · Substantial damage NTSB DEN68D0057Accident · Minor injuriesClosedCessna 150 · Aurora, COAug 2, 1967 · N4613X · Substantial damage NTSB NYC68F0063Accident · No injuriesClosedCessna 150G · Collegeville, PAAug 1, 1967 · N8307J · Substantial damage NTSB LAX68D0100Accident · No injuriesClosedCessna 150G · Phoenix, AZAug 1, 1967 · N8316J · 2 aircraft · Substantial damage NTSB FTW68A0011Accident · 1 fatalClosedCessna 150G · Victoria, TXJul 31, 1967 · N4645X · Destroyed NTSB MIA68D0075Accident · No injuriesClosedCessna 150 · Clarksville, TNJul 29, 1967 · N2938S · Substantial damage NTSB NYC68F0096Accident · No injuriesClosedCessna 150 · Medford, NJJul 26, 1967 · N2779S · Substantial damage NTSB FTW68F0142Accident · No injuriesClosedCessna 150 · Walnut Ridge, ARJul 26, 1967 · N3857J · Substantial damage NTSB CHI68F0191Accident · Serious injuriesClosedCessna 150 · Waynesville, OHJul 26, 1967 · N6248S · Substantial damage NTSB SEA68D0054Accident · No injuriesClosedCessna 150 · Missoula, MTJul 21, 1967 · N3130J · Substantial damage NTSB CHI68F0189Accident · No injuriesClosedCessna 150G · Traverse Cty, MIJul 11, 1967 · N8464J · Substantial damage NTSB LAX68D0037Accident · No injuriesClosedCessna 150 · Van Nuys, CAJul 5, 1967 · N4035J · Substantial damage NTSB MIA68D0041Accident · No injuriesClosedCessna 150 · Lithonia, GAJul 3, 1967 · N8607J · Substantial damage NTSB NYC68D0054Accident · No injuriesClosedCessna 150 · Ellington, CTJul 2, 1967 · N2211J · Substantial damage NTSB MKC68D0200Accident · Minor injuriesClosedCessna 150 · Bennington, KSJul 1, 1967 · N4780X · Substantial damage NTSB MKC67A0092Accident · 1 fatalClosedCessna 150G · So.St-Paul, MNJun 28, 1967 · N3160X · 2 aircraft · Destroyed NTSB MIA68D0070Accident · Minor injuriesClosedCessna 150 · Ft.Meyers, FLJun 28, 1967 · N3773J · Substantial damage NTSB CHI68D0091Accident · No injuriesClosedCessna 150 · Black R.Fall, WIJun 25, 1967 · N3679J · Substantial damage NTSB OAK68D0044Accident · No injuriesClosedCessna 150 · San Jose, CAJun 23, 1967 · N2878S · 2 aircraft · Minor damage NTSB MKC68F0014Accident · No injuriesClosedCessna 150G · Goddard, KSJun 22, 1967 · N2698J · Substantial damage NTSB CHI68D0049Accident · No injuriesClosedCessna 150 · Franklin, WIJun 21, 1967 · N3876J · Substantial damage NTSB SEA68D0073Accident · No injuriesClosedCessna 150 · Tacoma, WAJun 20, 1967 · N2723S · Substantial damage NTSB MKC68F0028Accident · Serious injuriesClosedCessna 150 · Canyon, MNJun 17, 1967 · N8693J · Substantial damage NTSB DIA68F0024Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDJun 16, 1967 · N3496J · Substantial damage NTSB MIA68D0049Accident · No injuriesClosedCessna 150 · Linden, ALJun 15, 1967 · N4608X · Substantial damage NTSB MIA67F0580Accident · No injuriesClosedCessna 150 · Ozark, ALJun 15, 1967 · N4642X · Substantial damage NTSB MKC68F0018Accident · No injuriesClosedCessna 150G · Pine City, MNJun 14, 1967 · N3322J · Substantial damage NTSB MKC68F0271Accident · No injuriesClosedCessna 150 · Orchard Farm, MOJun 13, 1967 · N3637J · Substantial damage

Back to Cessna 150G