Skip to content

NTSB investigations · 310

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 ('2071810') 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 ('2071810')
  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 ('2071810')
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 OAK66F0126Accident · Minor injuriesClosedCessna 150 · Hamilton Afb, CAAug 28, 1965 · N5975T · Substantial damage NTSB LAX66F0117Accident · No injuriesClosedCessna 150 · Van Nuys, CAAug 28, 1965 · N4384U · Substantial damage NTSB FTW66A0021Accident · 1 fatalClosedCessna 150D · Leander, TXAug 21, 1965 · N5970T · Destroyed NTSB NYC66D0218Accident · No injuriesClosedCessna 150 · New City, NYAug 11, 1965 · N5951T · Substantial damage NTSB OAK66A0005Accident · 1 fatalClosedCessna 150 · Stockton, CAAug 8, 1965 · N4351U · Destroyed NTSB FTW66D0220Accident · Minor injuriesClosedCessna 150 · Wilson, OKAug 3, 1965 · N4163U · Substantial damage NTSB NYC66D0077Accident · No injuriesClosedCessna 150 · Sussex, NJJul 26, 1965 · N4233U · Substantial damage NTSB MIA66D0069Accident · No injuriesClosedCessna 150D · Gillsburg, MSJul 24, 1965 · N4323U · Substantial damage NTSB CHI66D0197Accident · No injuriesClosedCessna 150 · Carrollton, OHJul 24, 1965 · N6015T · Substantial damage NTSB MIA66D0062Accident · No injuriesClosedCessna 150D · Columbia, TNJul 8, 1965 · N4486U · Substantial damage NTSB FTW66F0110Accident · No injuriesClosedCessna 150 · Houston, TXJun 22, 1965 · N6048T · Substantial damage NTSB MKC66F0072Accident · Minor injuriesClosedCessna 150 · Leawood, KSMay 15, 1965 · N4334U · Destroyed NTSB DEN66F0008Accident · Serious injuriesClosedCessna 150 · Montrose, COMay 6, 1965 · N4148U · Substantial damage NTSB FTW66F0034Accident · Minor injuriesClosedCessna 150 · Norman, OKMay 4, 1965 · N7989Z · Substantial damage NTSB MKC66F0007Accident · Minor injuriesClosedCessna 150 · Pine Bend, MNApr 30, 1965 · N4142U · Destroyed NTSB LAX65F0056Accident · No injuriesClosedCessna 150 · Compton, CAApr 29, 1965 · N4226U · Substantial damage NTSB FTW65D0027Accident · No injuriesClosedCessna 150 · Kaplan, LAApr 18, 1965 · N6040T · Destroyed NTSB DEN65F0063Accident · Minor injuriesClosedCessna 150 · Phoenix, AZApr 14, 1965 · N4544U · Destroyed NTSB MKC66F0003Accident · Minor injuriesClosedCessna 150 · Columbia, MOApr 12, 1965 · N6006T · Substantial damage NTSB MKC66F0005Accident · No injuriesClosedCessna 150 · Minneapolis, MNApr 4, 1965 · N6052T · Substantial damage NTSB MKC65F0094Accident · No injuriesClosedCessna 150D · Kenosha, WIApr 2, 1965 · N6020T · Substantial damage NTSB NYC65D0142Accident · No injuriesClosedCessna 150 · New Paltz, NYMar 25, 1965 · N4523U · Substantial damage NTSB NYC65F0093Accident · No injuriesClosedCessna 150 · Ware, MAMar 16, 1965 · N4209U · Substantial damage NTSB MKC65D0071Accident · No injuriesClosedCessna 150 · Holcomb, MOMar 11, 1965 · N4271U · Substantial damage NTSB MKC65D0064Accident · Minor injuriesClosedCessna 150 · Columbia, MOMar 9, 1965 · N4551U · Substantial damage NTSB SEA65D0026Accident · No injuriesClosedCessna 150 · Mitchel, ORMar 2, 1965 · N4320U · Substantial damage NTSB FTW66D0001Accident · No injuriesClosedCessna 150 · Washburn, TXFeb 18, 1965 · N4437U · Destroyed NTSB NYC65F0028Accident · No injuriesClosedCessna 150 · New Holland, PAFeb 8, 1965 · N5929T · Substantial damage NTSB UNK65X1402Accident · Minor injuriesClosedCessna 150 · Jonesboro, ARFeb 7, 1965 · N4540U · Destroyed NTSB UNK65X1366Accident · No injuriesClosedCessna 150D · Ft Worth, TXJan 28, 1965 · N4502U · Substantial damage NTSB UNK65X1341Accident · Minor injuriesClosedCessna 150 · Sacramento, CAJan 24, 1965 · N4396U · Substantial damage NTSB UNK65X0975Accident · No injuriesClosedCessna 150 · Blue Springs, MODec 11, 1964 · N4122U · Substantial damage NTSB UNK65X0830Accident · Minor injuriesClosedCessna 150D · Santa Monica, CANov 25, 1964 · N4240U · 2 aircraft · Substantial damage NTSB UNK65X0809Accident · 3 fatalClosedCessna 150D · Pomona, CANov 23, 1964 · N4359U · 2 aircraft · Destroyed NTSB UNK65X0743Accident · 2 fatalClosedCessna 150 · Cincinnati, OHNov 16, 1964 · N4350U · Destroyed NTSB UNK65X0680Accident · Serious injuriesClosedCessna 150 · Red Rock, AZNov 12, 1964 · N5940T · Destroyed NTSB UNK65X0651Accident · No injuriesClosedCessna 150 · Ramey Afb, PRNov 11, 1964 · N4275U · Substantial damage NTSB UNK65X0648Accident · No injuriesClosedCessna 150 · Johnson City, TNNov 10, 1964 · N4507U · Destroyed NTSB UNK65X0619Accident · No injuriesClosedCessna 150 · San Carlos, CANov 8, 1964 · N6055T · Substantial damage NTSB UNK65X0530Accident · No injuriesClosedCessna 150 · San Carlos, CANov 2, 1964 · N6065T · Substantial damage NTSB UNK65X0489Accident · No injuriesClosedCessna 150 · Riverside, CAOct 30, 1964 · N4444U · Substantial damage NTSB UNK65X0412Accident · 2 fatalClosedCessna 150 · Crestview, FLOct 24, 1964 · N6067T · Destroyed NTSB UNK65X0315AccidentClosedCessna 150 · Las Piedras, PROct 18, 1964 · N7995Z · Destroyed NTSB UNK64X4094Accident · No injuriesClosedCessna 150 · Hanover, NJSep 22, 1964 · N4491U · Substantial damage NTSB UNK64X3860Accident · No injuriesClosedCessna 150D · Boulder City, NVSep 7, 1964 · N901SW · Substantial damage NTSB UNK64X3689Accident · No injuriesClosedCessna 150 · Festus, MOAug 30, 1964 · N4286U · Substantial damage NTSB UNK64X3518Accident · No injuriesClosedCessna 150 · Midland, TXAug 21, 1964 · N4169U · Substantial damage NTSB UNK64X3424Accident · No injuriesClosedCessna 150 · Lauerne, CAAug 16, 1964 · N4270U · Substantial damage NTSB UNK64X3337Accident · Minor injuriesClosedCessna 150 · St Charles, MOAug 12, 1964 · N4310U · Destroyed NTSB UNK64X3299Accident · No injuriesClosedCessna 150 · Columbia, TNAug 9, 1964 · N4291U · Substantial damage

Back to Cessna 150D