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 LAX67D0129Accident · No injuriesClosedCessna 150 · Mesa, AZSep 8, 1966 · N4312U · Substantial damage NTSB MIA67F0216Accident · Minor injuriesClosedCessna 150D · No. Charleston, SCAug 8, 1966 · N5975T · Substantial damage NTSB OAK67D0064Accident · No injuriesClosedCessna 150 · Half Moon Bay, CAAug 6, 1966 · N5998T · Substantial damage NTSB NYC67D0136Accident · Minor injuriesClosedCessna 150 · East Hampton, CTAug 4, 1966 · N5929T · Substantial damage NTSB NYC67D0131Accident · No injuriesClosedCessna 150 · Meriden, CTJul 27, 1966 · N4569U · Substantial damage NTSB NYC67F0293Accident · No injuriesClosedCessna 150 · Endicott, NYJul 25, 1966 · N4308U · 2 aircraft · Substantial damage NTSB FTW67D0126Accident · No injuriesClosedCessna 150D · Giddings, TXJul 25, 1966 · N4340U · Substantial damage NTSB DEN67F0067Accident · Minor injuriesClosedCessna 150 · Sundance, WYJul 18, 1966 · N6061T · Substantial damage NTSB MKC67F0052Accident · Minor injuriesClosedCessna 150D · Bonner Sprgs, KSJul 6, 1966 · N4410U · Substantial damage NTSB NYC67F0048Accident · Minor injuriesClosedCessna 150D · Plainvile, CTJul 3, 1966 · N4209U · Substantial damage NTSB MIA66D0631Accident · No injuriesClosedCessna 150 · Humacao, PRJun 20, 1966 · N4108U · Substantial damage NTSB MIA66D0614Accident · No injuriesClosedCessna 150 · Thomaston, GAJun 5, 1966 · N6033T · Substantial damage NTSB FTW67F0010Accident · No injuriesClosedCessna 150D · Midland, TXJun 3, 1966 · N5962T · Substantial damage NTSB SEA67F0045Accident · No injuriesClosedCessna 150 · Bellevue, WAMay 31, 1966 · N4444U · Substantial damage NTSB DEN66D0355Accident · No injuriesClosedCessna 150 · Douglas, AZMay 30, 1966 · N4533U · Substantial damage NTSB DEN67D0020Accident · No injuriesClosedCessna 150 · Denver, COMay 28, 1966 · N7997Z · Substantial damage NTSB MKC66D0594Accident · No injuriesClosedCessna 150 · Emporia, KSMay 18, 1966 · N6063T · Substantial damage NTSB OAK66D0271Accident · Minor injuriesClosedCessna 150D · Yona, GUApr 16, 1966 · N4126U · Substantial damage NTSB LAX66F0314Accident · No injuriesClosedCessna 150 · Hawthorne, CAApr 8, 1966 · N4372U · Substantial damage NTSB DEN66D0288Accident · No injuriesClosedCessna 150 · Wickenburg, AZMar 26, 1966 · N4448U · Substantial damage NTSB MKC65F0485Accident · No injuriesClosedCessna 150D · Kennett, MOMar 21, 1966 · N4303U · Substantial damage NTSB CHI66D0634Accident · No injuriesClosedCessna 150 · Strongsville, OHMar 13, 1966 · N4344U · Substantial damage NTSB NYC66D0533Accident · No injuriesClosedCessna 150 · Friendly, MDFeb 26, 1966 · N5954T · Substantial damage NTSB CHI66F0592Accident · Serious injuriesClosedCessna 150 · Milwaukee, WIFeb 15, 1966 · N6042T · Substantial damage NTSB MKC66D0440Accident · No injuriesClosedCessna 150 · Coates, MNFeb 12, 1966 · N4142U · Substantial damage NTSB NYC66D0503Accident · No injuriesClosedCessna 150 · Teterboro, NJFeb 6, 1966 · N4233U · Substantial damage NTSB FTW66F0519Accident · No injuriesClosedCessna 150 · Dickinson, TXFeb 4, 1966 · N4155U · Substantial damage NTSB NYC66D0554Accident · No injuriesClosedCessna 150 · Newport, RIJan 29, 1966 · N4404U · Substantial damage NTSB LAX66D0224Accident · No injuriesClosedCessna 150 · Piru, CAJan 18, 1966 · N4240U · Substantial damage NTSB MKC66D0306Accident · No injuriesClosedCessna 150 · Cohasset, MNJan 2, 1966 · N4489U · Substantial damage NTSB CHI66F0552Accident · No injuriesClosedCessna 150 · West Chicago, ILDec 29, 1965 · N4119U · Substantial damage NTSB CHI66D0499Accident · No injuriesClosedCessna 150 · Farmington, ILDec 27, 1965 · N5939T · Substantial damage NTSB OAK66F0181Accident · No injuriesClosedCessna 150D · Lincoln, CADec 18, 1965 · N4316U · 2 aircraft · Substantial damage NTSB FTW66D0448Accident · No injuriesClosedCessna 150 · Houston, TXDec 8, 1965 · N5911T · Substantial damage NTSB MIA66D0419Accident · 1 fatalClosedCessna 150 · Marathon, FLNov 28, 1965 · N4318U · Substantial damage NTSB DEN66D0177Accident · No injuriesClosedCessna 150 · Tucson, AZNov 26, 1965 · N4138U · Substantial damage NTSB LAX66F0182Accident · No injuriesClosedCessna 150 · 29 Palms, CANov 12, 1965 · N4546U · Substantial damage NTSB OAK66D0160Accident · No injuriesClosedCessna 150 · Alameda, CAOct 18, 1965 · N4355U · Substantial damage NTSB DEN66D0121Accident · No injuriesClosedCessna 150 · Albuquerque, NMOct 16, 1965 · N4376U · Substantial damage NTSB NYC66F0282Accident · No injuriesClosedCessna 150D · Farmingdale, NJOct 11, 1965 · N4473U · Substantial damage NTSB NYC66D0369Accident · No injuriesClosedCessna 150 · Spring Valley, NYOct 2, 1965 · N5969T · Substantial damage NTSB NYC66D0318Accident · No injuriesClosedCessna 150 · Middletown, DEOct 2, 1965 · N5934T · Substantial damage NTSB MKC66F0269Accident · Serious injuriesClosedCessna 150 · N.Greenwald, MNOct 1, 1965 · N5948T · Destroyed NTSB MKC66F0279Accident · Minor injuriesClosedCessna 150 · Bloomsdale, MOSep 25, 1965 · N4391U · Destroyed NTSB FTW66F0312Accident · Serious injuriesClosedCessna 150 · Westwego, LASep 23, 1965 · N4323U · Substantial damage NTSB CHI66A0025Accident · 1 fatalClosedCessna 150 · Louisville, KYSep 10, 1965 · N4564U · 2 aircraft · Destroyed NTSB MKC66D0274Accident · No injuriesClosedCessna 150 · Lacygne, KSSep 6, 1965 · N4203U · Substantial damage NTSB NYC66F0193Accident · Minor injuriesClosedCessna 150D · Franconia, NHAug 30, 1965 · N4556U · Substantial damage NTSB LAX66D0089Accident · No injuriesClosedCessna 150 · El Monte, CAAug 29, 1965 · N4354U · Substantial damage NTSB CHI66F0314Accident · No injuriesClosedCessna 150 · Northbrook, ILAug 29, 1965 · N4429U · 2 aircraft · Substantial damage

Back to Cessna 150D