Skip to content

NTSB investigations · 162

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 ('2071808') 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 ('2071808')
  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 ('2071808')
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 MIA67D0306Accident · No injuriesClosedCessna 150 · Agricola, MSDec 3, 1966 · N7860Z · Substantial damage NTSB CHI67F0256Accident · No injuriesClosedCessna 150 · Ypsilanti, MIOct 20, 1966 · N1929Z · Substantial damage NTSB LAX67F0176Accident · Minor injuriesClosedCessna 150 · Phoenix, AZOct 15, 1966 · N7802Z · Substantial damage NTSB OAK67D0110Accident · No injuriesClosedCessna 150 · San Carlos, CAOct 8, 1966 · N7941Z · Substantial damage NTSB LAX67D0109Accident · Minor injuriesClosedCessna 150 · Banning, CASep 10, 1966 · N7856Z · Substantial damage NTSB MIA67F0111Accident · Serious injuriesClosedCessna 150 · Hernando, MSAug 6, 1966 · N7978Z · Substantial damage NTSB DEN67D0053Accident · No injuriesClosedCessna 150 · Roosevelt, UTJul 23, 1966 · N2079Z · Substantial damage NTSB MKC67F0105Accident · No injuriesClosedCessna 150 · Waldron, MOJul 19, 1966 · N7898Z · Substantial damage NTSB OAK67D0032Accident · No injuriesClosedCessna 150 · Kauakakai, HIJul 6, 1966 · N2061Z · Substantial damage NTSB FTW66D0701Accident · No injuriesClosedCessna 150C · Ben Wheeler, TXJun 7, 1966 · N2067Z · Substantial damage NTSB NYC66F0669Accident · No injuriesClosedCessna 150 · West Mifflin, PAMay 26, 1966 · N7944Z · Substantial damage NTSB SEA66D0283Accident · No injuriesClosedCessna 150C · Orofino, IDMay 16, 1966 · N1964Z · Substantial damage NTSB MKC66D0564Accident · No injuriesClosedCessna 150 · Houston, MOApr 27, 1966 · N1922Z · Destroyed NTSB LAX66A0075Accident · 1 fatalClosedCessna 150 · ZApr 1, 1966 · N7926Z · Destroyed NTSB FTW66F0543Accident · No injuriesClosedCessna 150C · Spade, TXFeb 20, 1966 · N1944Z · Substantial damage NTSB NYC66D0476Accident · No injuriesClosedCessna 150 · Pittstown, NJJan 29, 1966 · N7819Z · Substantial damage NTSB MKC66F0271Accident · Minor injuriesClosedCessna 150 · Grand Forks, NDOct 4, 1965 · N2085Z · 2 aircraft · Substantial damage NTSB MKC66F0268Accident · Minor injuriesClosedCessna 150 · Warrensburg, MOSep 28, 1965 · N7938Z · Substantial damage NTSB FTW66F0325Accident · No injuriesClosedCessna 150 · Genoa, TXSep 27, 1965 · N7972Z · Substantial damage NTSB NYC66D0241Accident · No injuriesClosedCessna 150 · Laurel, DESep 15, 1965 · N7840Z · Substantial damage NTSB CHI66F0314Accident · No injuriesClosedCessna 150 · Northbrook, ILAug 29, 1965 · N7954Z · 2 aircraft · Substantial damage NTSB OAK66D0105Accident · No injuriesClosedCessna 150 · San Jose, CAAug 21, 1965 · N7870Z · Substantial damage NTSB NYC66D0132Accident · No injuriesClosedCessna 150 · Deer Park, NYJul 25, 1965 · N7910Z · Substantial damage NTSB CHI66A0009Accident · 1 fatalClosedCessna 150C · Wausau, WIJul 18, 1965 · N7936Z · Destroyed NTSB MKC66F0124Accident · No injuriesClosedCessna 150 · Hatton, NDJun 27, 1965 · N2074Z · Substantial damage NTSB FTW66F0111Accident · No injuriesClosedCessna 150 · Pearland, TXJun 22, 1965 · N1985Z · Destroyed NTSB SEA66D0010Accident · No injuriesClosedCessna 150 · Everett, WAJun 21, 1965 · N2023Z · Substantial damage NTSB FTW66F0106Accident · Minor injuriesClosedCessna 150C · Gilmer, TXJun 21, 1965 · N2002Z · Substantial damage NTSB ANC65F0019Accident · Serious injuriesClosedCessna 150C · Talkeetna, AKJun 5, 1965 · N2012Z · Destroyed NTSB MIA65D0022Accident · No injuriesClosedCessna 150 · Ft Brasinger, FLMar 27, 1965 · N1935Z · Substantial damage NTSB MIA65A0092Accident · 1 fatalClosedCessna 150G · Auburn, ALMar 14, 1965 · N7966Z · Substantial damage NTSB UNK65X1431Accident · No injuriesClosedCessna 150 · Homestead, FLFeb 17, 1965 · N1947Z · Substantial damage NTSB MIA65A0077Accident · 3 fatalClosedCessna 150 · Americus, GAJan 26, 1965 · N7901Z · Destroyed NTSB UNK65X1298Incident · No injuriesClosedCessna 150 · Mineral Wells, TXJan 17, 1965 · N7812Z · 2 aircraft · Minor damage NTSB UNK65X1260Accident · No injuriesClosedCessna 150 · Mattituck, NYJan 9, 1965 · N7950Z · Substantial damage NTSB UNK65X1232Accident · No injuriesClosedCessna 150 · Homestead, FLJan 5, 1965 · N1943Z · Substantial damage NTSB UNK65X1163Accident · 1 fatalClosedCessna 150C · Tallahassee, FLDec 27, 1964 · N991KW · Destroyed NTSB UNK65X0830Accident · Minor injuriesClosedCessna 150C · Santa Monica, CANov 25, 1964 · N1992Z · 2 aircraft · Minor damage NTSB UNK65X0252Accident · 2 fatalClosedCessna 150C · Chino, CAOct 12, 1964 · N1905Z · Destroyed NTSB UNK64X3782Accident · Minor injuriesClosedCessna 150 · Madison, MSSep 5, 1964 · N7960Z · Substantial damage NTSB UNK64X3418Accident · No injuriesClosedCessna 150 · Jamestown, NDAug 16, 1964 · N2074Z · Substantial damage NTSB UNK64X3376Accident · No injuriesClosedCessna 150 · Peoples, AZAug 14, 1964 · N1975Z · Substantial damage NTSB UNK64X2754Accident · Minor injuriesClosedCessna 150 · Butler, ALJul 10, 1964 · N7966Z · Substantial damage NTSB UNK64X2600Accident · 1 fatalClosedCessna 150 · Branford, FLJul 1, 1964 · N1937Z · Destroyed NTSB UNK64X2458Accident · No injuriesClosedCessna 150C · Wichita, KSJun 24, 1964 · N7974Z · Destroyed NTSB UNK64X2192Accident · Minor injuriesClosedCessna 150 · Hopkins, MNJun 8, 1964 · N7827Z · Destroyed NTSB UNK64X2067Accident · Minor injuriesClosedCessna 150C · Medora, KSJun 2, 1964 · N7882Z · Substantial damage NTSB UNK64X1846Accident · No injuriesClosedCessna 150 · Walnut Grove, CAMay 19, 1964 · N2068Z · Substantial damage NTSB UNK64X1592Accident · Minor injuriesClosedCessna 150 · Santa Rosa, CAMay 3, 1964 · N7879Z · 2 aircraft · Destroyed NTSB UNK64X1592Accident · Minor injuriesClosedCessna 150 · Santa Rosa, CAMay 3, 1964 · N7948Z · 2 aircraft · Substantial damage

Back to Cessna 150C