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 MIA72FKG88Accident · No injuriesClosedCessna 150G · Winston, GAApr 18, 1972 · N4750X · Substantial damage NTSB MIA72DLA40Accident · No injuriesClosedCessna 150 · Destin, FLApr 14, 1972 · N6240S · Substantial damage NTSB OAK73OJA02Accident · No injuriesClosedCessna 150G · Clark Afbase, RPApr 11, 1972 · N3843S · Substantial damage NTSB NYC72DNC37Accident · No injuriesClosedCessna 150 · Auburn, MEApr 9, 1972 · N3610J · Substantial damage NTSB LAX72DUG68Accident · No injuriesClosedCessna 150G · Perris, CAMar 31, 1972 · N8499J · Substantial damage NTSB OAK72DVG45Accident · Serious injuriesClosedCessna 150 · Paradise, CAMar 23, 1972 · N4053J · Destroyed NTSB DEN72FTE66Accident · No injuriesClosedCessna 150G · Englewood, COMar 23, 1972 · N6250S · Substantial damage NTSB NYC72FID21Accident · No injuriesClosedCessna 150 · Charles City, VAMar 4, 1972 · N8570J · Substantial damage NTSB NYC72FLJ25Accident · No injuriesClosedCessna 150 · Louisburg, NCFeb 16, 1972 · N4051J · Substantial damage NTSB ANC72DAG93Accident · No injuriesClosedCessna 150G · Palmer, AKFeb 13, 1972 · N6288S · Substantial damage NTSB CHI72AC064Accident · 2 fatalClosedCessna 150G · Springfield, OHFeb 12, 1972 · N3629J · 2 aircraft · Destroyed NTSB FTW72AF050Accident · 2 fatalClosedCessna 150G · Bono, ARFeb 10, 1972 · N6350S · Destroyed NTSB CHI72FEM48Accident · No injuriesClosedCessna 150 · Traverse Cty, MIJan 21, 1972 · N8425J · Substantial damage NTSB NYC72DFJ26Accident · No injuriesClosedCessna 150 · Lockport, NYJan 8, 1972 · N3862J · Substantial damage NTSB MIA72AM065Accident · 3 fatalClosedCessna 150G · San Mateo, FLJan 6, 1972 · N3642J · 2 aircraft · Destroyed NTSB SEA72AS027Accident · 1 fatalClosedCessna 150G · Kalama, WADec 31, 1971 · N2257J · Destroyed NTSB DEN72DTE52Accident · Minor injuriesClosedCessna 150 · Walsenburg, CODec 27, 1971 · N3082S · Substantial damage NTSB MKC72DER32Accident · No injuriesClosedCessna 150G · Lesueur, MNDec 5, 1971 · N2434J · Substantial damage NTSB OAK72DJA09Accident · 1 fatalClosedCessna 150G · Honokaa, HIDec 2, 1971 · N3904J · Destroyed NTSB LAX72FUG37Accident · No injuriesClosedCessna 150 · El Monte, CANov 22, 1971 · N4035J · Substantial damage NTSB DEN72DTE43Accident · No injuriesClosedCessna 150G · Broomfield, CONov 13, 1971 · N3484J · Substantial damage NTSB OAK72DVM10Accident · No injuriesClosedCessna 150 · Morgan Hill, CAOct 31, 1971 · N2829S · Substantial damage NTSB NYC72FFJ20Accident · Minor injuriesClosedCessna 150G · Auburn, NYOct 28, 1971 · N4039J · Substantial damage NTSB MIA72DLA18Accident · Minor injuriesClosedCessna 150G · Micanopy, FLOct 28, 1971 · N3281J · Substantial damage NTSB OAK72FVD22Accident · No injuriesClosedCessna 150G · Lodi, CAOct 25, 1971 · N3405J · 2 aircraft · Substantial damage NTSB OAK72AP012Accident · Minor injuriesClosedCessna 150 · Franklin, CAOct 25, 1971 · N4687X · 2 aircraft · Substantial damage NTSB DEN72FTE34Accident · No injuriesClosedCessna 150 · Aurora, COOct 20, 1971 · N3731J · Substantial damage NTSB MKC72DCG29Accident · Serious injuriesClosedCessna 150 · Leawood, KSOct 17, 1971 · N2494J · No damage NTSB FTW72FRG32Accident · Minor injuriesClosedCessna 150G · San Antonio, TXOct 11, 1971 · N2464J · Substantial damage NTSB CHI72FEM34Accident · No injuriesClosedCessna 150G · Montague, MISep 24, 1971 · N3444J · Substantial damage NTSB NYC72DFA15Accident · No injuriesClosedCessna 150 · Selkirk, NYSep 16, 1971 · N2413J · Substantial damage NTSB FTW72DPG37Accident · Minor injuriesClosedCessna 150G · Abbott, ARSep 5, 1971 · N6296S · Substantial damage NTSB FTW72DPD10Accident · No injuriesClosedCessna 150 · Graford, TXSep 5, 1971 · N3416J · Substantial damage NTSB FTW72DPM06Accident · No injuriesClosedCessna 150 · Skiatook, OKAug 28, 1971 · N3474J · Substantial damage NTSB SEA72FYI08Accident · Serious injuriesClosedCessna 150G · Paisley, ORAug 26, 1971 · N3837J · Destroyed NTSB OAK72FXQ12Accident · Serious injuriesClosedCessna 150G · Imlay, NVAug 26, 1971 · N4083J · Substantial damage NTSB MKC72DCD30Accident · No injuriesClosedCessna 150G · Knoxville, IAAug 25, 1971 · N3012S · Substantial damage NTSB MKC72DCA06Accident · No injuriesClosedCessna 150C · Poplar Bluff, MOAug 25, 1971 · N8434J · Substantial damage NTSB MKC72DCD27Accident · No injuriesClosedCessna 150G · Calamus, IAAug 21, 1971 · N4738X · Substantial damage NTSB MIA72IM013Incident · 1 fatalClosedCessna 150G · Foley, ALAug 17, 1971 · N3984J · No damage NTSB MIA72DKG23Accident · No injuriesClosedCessna 150G · Gray, GAAug 16, 1971 · N3301J · Substantial damage NTSB LAX72FUM07Accident · No injuriesClosedCessna 150G · San Diego, CAAug 10, 1971 · N2645J · Substantial damage NTSB OAK72DVA06Accident · No injuriesClosedCessna 150 · Hanford, CAAug 9, 1971 · N2249J · Substantial damage NTSB NYC72FGM08Accident · Serious injuriesClosedCessna 150G · Valencia, PAAug 6, 1971 · N3787J · Substantial damage NTSB SEA72FYC11Accident · No injuriesClosedCessna 150 · Albany, ORJul 27, 1971 · N3625J · Substantial damage NTSB ANC72AA005Accident · 2 fatalClosedCessna 150G · Petersburg, AKJul 25, 1971 · N8697J · Substantial damage NTSB MIA72DLA01Accident · No injuriesClosedCessna 150G · Quincy, FLJul 24, 1971 · N4755X · Substantial damage NTSB MKC72DER07Accident · No injuriesClosedCessna 150 · Princeton, MNJul 22, 1971 · N3653J · Substantial damage NTSB OAK72DVD01Accident · Minor injuriesClosedCessna 150 · San Frncsco, CAJul 11, 1971 · N3766J · Destroyed NTSB CHI72DEI05Accident · Minor injuriesClosedCessna 150G · Luckey, OHJul 8, 1971 · N3194J · Substantial damage

Back to Cessna 150G