Skip to content

NTSB investigations · 132

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 ('2071804') 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 ('2071804')
  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 ('2071804')
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 MIA70DKW07Accident · No injuriesClosedCessna 150 · Madisonville, TNMay 17, 1970 · N7170X · Substantial damage NTSB LAX70A0032Accident · No injuriesClosedCessna 150A · Santa Paula, CADec 9, 1969 · N7043X · 2 aircraft · Substantial damage NTSB LAX70F0201Accident · Serious injuriesClosedCessna 150 · Sta.Susana, CANov 8, 1969 · N7201X · Destroyed NTSB SEA70F0139Accident · Serious injuriesClosedCessna 150 · Millican, OROct 18, 1969 · N7163X · Destroyed NTSB CHI70A0002Accident · 1 fatalClosedCessna 150 · Odell, ILJul 3, 1969 · N7156X · Destroyed NTSB MIA70D0085Accident · No injuriesClosedCessna 150 · Faunsdale, ALJun 12, 1969 · N7153X · Substantial damage NTSB CHI69F0609Accident · Minor injuriesClosedCessna 150 · Cincinnati, OHMay 4, 1969 · N6620T · Destroyed NTSB NYC70D0060Accident · No injuriesClosedCessna 150 · Rochester, NHApr 4, 1969 · N7157X · Substantial damage NTSB CHI69F0542Accident · No injuriesClosedCessna 150 · Almena, MIMar 17, 1969 · N7071X · Substantial damage NTSB MKC69F0338Accident · No injuriesClosedCessna 150A · Denison, IAFeb 18, 1969 · N7236X · Substantial damage NTSB DIA69A0039Accident · 1 fatalClosedCessna 150 · Flintstone, MDFeb 2, 1969 · N7244X · Destroyed NTSB LAX69D0206Accident · No injuriesClosedCessna 150 · Yucca Valley, CANov 21, 1968 · N6655T · Substantial damage NTSB CHI69D0138Accident · No injuriesClosedCessna 150 · Ossian, INAug 1, 1968 · N6635T · Substantial damage NTSB CHI69F0077Accident · Minor injuriesClosedCessna 150 · Armada, MIJul 22, 1968 · N7035X · Substantial damage NTSB FTW68F0617Accident · No injuriesClosedCessna 150 · Lewisville, TXJun 9, 1968 · N7171X · Substantial damage NTSB MKC68F0532Accident · No injuriesClosedCessna 150 · Mankato, MNApr 25, 1968 · N7037X · Substantial damage NTSB MIA68D0489Accident · No injuriesClosedCessna 150 · Roswell, GAApr 6, 1968 · N6622T · Substantial damage NTSB LAX68D0369Accident · No injuriesClosedCessna 150 · El Monte, CAApr 6, 1968 · N6685T · Substantial damage NTSB LAX68D0349Accident · No injuriesClosedCessna 150 · Compton, CAMar 30, 1968 · N8916S · Substantial damage NTSB MIA68D0400Accident · No injuriesClosedCessna 150 · Miami, FLJan 19, 1968 · N7018X · 2 aircraft · Minor damage NTSB FTW68D0092Accident · No injuriesClosedCessna 150 · Arlington, TXJul 12, 1967 · N7220X · Substantial damage NTSB MIA67F0562Accident · Minor injuriesClosedCessna 150 · Onward, MSMay 10, 1967 · N6637T · Substantial damage NTSB MIA67D0508Accident · No injuriesClosedCessna 150A · Andyton, FLMay 4, 1967 · N7027X · Substantial damage NTSB DIA68F0066Accident · No injuriesClosedCessna 150 · Woodbridge, VAApr 30, 1967 · N7007X · Substantial damage NTSB DIA67A0014Accident · 2 fatalClosedCessna 150A · Wakefield, VAApr 16, 1967 · N7013X · Destroyed NTSB CHI67F0493Accident · No injuriesClosedCessna 150 · Delaware, OHFeb 22, 1967 · N7159X · Substantial damage NTSB LAX67D0299Accident · No injuriesClosedCessna 150 · Thermal, CAFeb 5, 1967 · N8916S · Substantial damage NTSB CHI67D0448Accident · No injuriesClosedCessna 150A · Newport, INJan 11, 1967 · N7012X · Substantial damage NTSB FTW67F0306Accident · No injuriesClosedCessna 150A · Abilene, TXNov 26, 1966 · N6669T · Destroyed NTSB FTW67F0323Accident · No injuriesClosedCessna 150 · San Antonio, TXNov 12, 1966 · N7036X · Substantial damage NTSB MKC67F0358Accident · Minor injuriesClosedCessna 150A · Tioga, NDNov 5, 1966 · N7114X · Substantial damage NTSB FTW67D0256Accident · No injuriesClosedCessna 150 · Pearsall, TXOct 1, 1966 · N7249X · Substantial damage NTSB MKC67F0272Accident · No injuriesClosedCessna 150 · Rosemount, MNSep 27, 1966 · N6684T · 2 aircraft · Substantial damage NTSB CHI67D0195Accident · No injuriesClosedCessna 150A · Stevens Point, WISep 12, 1966 · N7217X · Substantial damage NTSB NYC67D0170Accident · No injuriesClosedCessna 150 · Westford, CTAug 28, 1966 · N7169X · Substantial damage NTSB LAX67A0018Accident · 1 fatalClosedCessna 150A · S.Catalina Is., CAAug 9, 1966 · N7160X · Destroyed NTSB NYC67D0084Accident · No injuriesClosedCessna 150 · Clinton, MDJul 20, 1966 · N7007X · Substantial damage NTSB MIA67D0049Accident · No injuriesClosedCessna 150 · Fayetteville, GAJun 27, 1966 · N7181X · Substantial damage NTSB LAX66F0371Accident · No injuriesClosedCessna 150 · Lompoc, CAJun 2, 1966 · N7161X · Substantial damage NTSB LAX66D0361Accident · No injuriesClosedCessna 150 · Ojai, CAMay 25, 1966 · N6685T · Substantial damage NTSB NYC66D0671Accident · No injuriesClosedCessna 150 · Mt.Pocono, PAMay 15, 1966 · N7016X · Substantial damage NTSB FTW67F0002Accident · Minor injuriesClosedCessna 150 · Arren, ARMay 6, 1966 · N7170X · Substantial damage NTSB DEN66F0252Accident · No injuriesClosedCessna 150 · Broomfield, COFeb 20, 1966 · N7064X · Substantial damage NTSB LAX66F0242Accident · No injuriesClosedCessna 150 · Lompoc, CAFeb 12, 1966 · N7161X · Substantial damage NTSB LAX66F0245Accident · Minor injuriesClosedCessna 150 · San Diego, CAJan 25, 1966 · N7125X · Substantial damage NTSB LAX66D0227Accident · No injuriesClosedCessna 150 · Burbank, CAJan 20, 1966 · N830SR · Substantial damage NTSB SEA66D0206Accident · No injuriesClosedCessna 150 · Scappoose, ORJan 18, 1966 · N7024X · Substantial damage NTSB MIA66F0549Accident · No injuriesClosedCessna 150 · Pensacola, FLJan 16, 1966 · N7059X · Substantial damage NTSB ANC66A0085Accident · Minor injuriesClosedCessna 150 · Anchorage, AKJan 14, 1966 · N7085X · Substantial damage NTSB MKC66F0345Accident · No injuriesClosedCessna 150 · Lincoln, NEDec 30, 1965 · N7236X · Substantial damage

Back to Cessna 150A