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 MKC68F0481Accident · Minor injuriesClosedCessna 150 · Ferrelview, MOFeb 18, 1968 · N8545J · Destroyed NTSB LAX68D0340Accident · No injuriesClosedCessna 150 · Banning, CAFeb 18, 1968 · N3144J · Substantial damage NTSB FTW68F0434Accident · No injuriesClosedCessna 150 · Alexandria, LAFeb 8, 1968 · N2915J · Substantial damage NTSB CHI68F0573Accident · Minor injuriesClosedCessna 150G · Midlothian, ILFeb 3, 1968 · N3200J · Substantial damage NTSB MKC68D0439Accident · Minor injuriesClosedCessna 150G · Dubuque, IAJan 30, 1968 · N3954J · Substantial damage NTSB OAK68D0298Accident · No injuriesClosedCessna 150 · Port Chicago, CAJan 20, 1968 · N3392J · Substantial damage NTSB MIA68D0400Accident · No injuriesClosedCessna 150 · Miami, FLJan 19, 1968 · N3940J · 2 aircraft · Substantial damage NTSB NYC68A0091Accident · 1 fatalClosedCessna 150G · Westminster, MAJan 13, 1968 · N3195J · Destroyed NTSB CHI68D0544Accident · No injuriesClosedCessna 150 · Superior, WIJan 13, 1968 · N2707S · Substantial damage NTSB NYC68D0327Accident · No injuriesClosedCessna 150 · Plainville, CTJan 6, 1968 · N3790J · Substantial damage NTSB OAK68D0251Accident · No injuriesClosedCessna 150 · Garberville, CAJan 3, 1968 · N4725X · Substantial damage NTSB NYC68F0324Accident · No injuriesClosedCessna 150 · Leroy, NYJan 2, 1968 · N2260J · Substantial damage NTSB DIA68D0143Accident · No injuriesClosedCessna 150G · Crewe, VADec 31, 1967 · N8535J · Substantial damage NTSB CHI68D0522Accident · No injuriesClosedCessna 150G · Carbondale, ILDec 26, 1967 · N3191J · Substantial damage NTSB NYC68F0322Accident · No injuriesClosedCessna 150G · Hartford, CTDec 20, 1967 · N3237J · Substantial damage NTSB NYC68F0313Accident · No injuriesClosedCessna 150G · Wallkill, NYDec 17, 1967 · N3346J · Substantial damage NTSB MKC68F0391Accident · Minor injuriesClosedCessna 150 · Rosemount, MNDec 16, 1967 · N2484J · Substantial damage NTSB MIA68D0369Accident · No injuriesClosedCessna 150 · Pell City, ALDec 16, 1967 · N3316J · Substantial damage NTSB OAK68D0304Accident · No injuriesClosedCessna 150 · Vacaville, CADec 13, 1967 · N2400J · Substantial damage NTSB CHI68F0446Accident · No injuriesClosedCessna 150G · Ypsilanti, MIDec 13, 1967 · N2776S · Substantial damage NTSB FTW68F0384Accident · No injuriesClosedCessna 150G · Addison, TXDec 12, 1967 · N2731S · Substantial damage NTSB MKC68D0378Accident · No injuriesClosedCessna 150 · Creve Coeur, MODec 6, 1967 · N3457J · Substantial damage NTSB MKC68D0376Accident · No injuriesClosedCessna 150 · Wykoff, MNDec 3, 1967 · N8671J · Substantial damage NTSB NYC68F0329Accident · No injuriesClosedCessna 150G · Bellefonte, PADec 1, 1967 · N904PS · Substantial damage NTSB FTW68F0367Accident · No injuriesClosedCessna 150G · Lancaster, TXNov 27, 1967 · N2880S · Substantial damage NTSB OAK68F0255Accident · Minor injuriesClosedCessna 150 · Kadena, JANov 25, 1967 · N4087J · Destroyed NTSB FTW68D0342Accident · No injuriesClosedCessna 150G · San Antonio, TXNov 25, 1967 · N2632J · Substantial damage NTSB FTW68D0354Accident · No injuriesClosedCessna 150 · Sand Springs, OKNov 20, 1967 · N3288J · Substantial damage NTSB MIA68D0365Accident · No injuriesClosedCessna 150G · Enterprise, ALNov 19, 1967 · N6345S · Substantial damage NTSB UNK68X0107Incident · No injuriesClosedCessna 150F · Livermore, CANov 14, 1967 · N6369S · 2 aircraft · Minor damage NTSB CHI68D0504Accident · No injuriesClosedCessna 150 · Mansfield, OHNov 8, 1967 · N6209S · Substantial damage NTSB MKC68D0277Accident · No injuriesClosedCessna 150 · Hamburg, IANov 6, 1967 · N3128J · Substantial damage NTSB FTW68D0328Accident · No injuriesClosedCessna 150G · Rosenberg, TXNov 5, 1967 · N3340J · Substantial damage NTSB OAK68A0039Accident · 2 fatalClosedCessna 150G · Beckwourth, CANov 3, 1967 · N3704J · Destroyed NTSB MIA68D0304Accident · No injuriesClosedCessna 150 · Davie, FLNov 2, 1967 · N8366J · Substantial damage NTSB NYC68F0269Accident · No injuriesClosedCessna 150 · Teterboro, NJOct 29, 1967 · N8398J · 2 aircraft · Substantial damage NTSB OAK68D0181Accident · Minor injuriesClosedCessna 150G · Concord, CAOct 28, 1967 · N4027J · Substantial damage NTSB FTW68F0313Accident · No injuriesClosedCessna 150G · Austin, TXOct 28, 1967 · N3737J · Substantial damage NTSB FTW68D0314Accident · No injuriesClosedCessna 150 · Mcallen, TXOct 28, 1967 · N3725J · Substantial damage NTSB MIA68F0300Accident · No injuriesClosedCessna 150G · W Hollywood, FLOct 25, 1967 · N4744X · Substantial damage NTSB DIA68D0115Accident · No injuriesClosedCessna 150G · Basye, VAOct 24, 1967 · N3711J · Substantial damage NTSB CHI68D0372Accident · No injuriesClosedCessna 150 · Indianapolis, INOct 23, 1967 · N3764J · Substantial damage NTSB NYC68D0263Accident · Minor injuriesClosedCessna 150 · Toms River, NJOct 21, 1967 · N2901S · Substantial damage NTSB LAX68A0041Accident · 4 fatalClosedCessna 150G · W.Los Angeles, CAOct 18, 1967 · N8301J · 2 aircraft · Destroyed NTSB DEN68D0111Accident · No injuriesClosedCessna 150 · Pierce, COOct 15, 1967 · N3614J · Substantial damage NTSB CHI68D0390Accident · No injuriesClosedCessna 150 · Streator, ILOct 14, 1967 · N3093S · Substantial damage NTSB FTW68F0282Accident · Minor injuriesClosedCessna 150 · Ferris, TXOct 13, 1967 · N8469J · Destroyed NTSB DEN68F0119Accident · Minor injuriesClosedCessna 150G · Aurora, COOct 10, 1967 · N4077J · Substantial damage NTSB OAK68A0034Accident · 2 fatalClosedCessna 150G · Las Vegas, NVOct 8, 1967 · N3229J · 2 aircraft · Destroyed NTSB LAX68A0039Accident · 2 fatalClosedCessna 150 · Compton, CAOct 6, 1967 · N2967J · Destroyed

Back to Cessna 150G