NTSB investigations · 17

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 ('1520204') 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 ('1520204')
  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 ('1520204')
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 CEN22FA031Accident · 4 fatalClass 3 · FieldFinal reportBritten-Norman BN-2A · Beaver Island, MIThe pilot's exceedance of the airplane's critical angle of attack during final approach, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.Nov 13, 2021 · N866JA · Substantial damage NTSB ANC04LA113Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A · Kodiak, AKThe pilot's inadequate compensation for wind conditions, and his intentional flight into adverse weather conditions, which resulted in a loss of control and collision with terrain during takeoff-initial climb. Factors contributing to the accident were high…Sep 23, 2004 · N6522T · Substantial damage NTSB ANC99LA006Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2A · English Bay, AKThe pilot-in-command's inadequate compensation for the crosswind conditions, and failure to maintain adequate clearance from the parked airplane. Factors associated with this accident were the gusty crosswinds, and the congested takeoff area due to no parking…Oct 16, 1998 · N6522T · Substantial damage NTSB LAX91WA031Accident · No injuriesForeign investigationBritten-Norman BN-2A · Pohnpei (Pacific Ocean)Nov 15, 1990 · N87877 · Destroyed NTSB DCA90MA010Accident · 8 fatalMajor investigationFinal reportBritten-Norman BN-2 · Block Island, RIThe aircraft crashed for an undetermined reason, during an overwater flight on a dark (moonless) night under a cloud layer. A SIGMET was in effect warning of moderate to occasionally severe turbulence below 6000 feet and the potential of low level wind shear.Nov 28, 1989 · N127JL · Destroyed NTSB MIA89FA065Accident · No injuriesField investigationFinal reportBritten-Norman BN-2A · Carolina, PRFuel exhaustion and the failure of the pilot to insure that the proper fuel load was placed on the aircraft for the flight. Contributing factors included the improper refueling of the aircraft, improper initial training of the refueler and the crop, which…Jan 16, 1989 · N457SA · Substantial damage NTSB SEA88FA167Accident · 1 fatalField investigationFinal reportBritten-Norman BN-2A · Sitka, AKThe pilot encountered low ceilings, rain and fog while attempting to fly through a narrow mountain pass and successfully reversed course. He then flew into a small canyon off the main pass that terminated in a small glacier-covered bowl surrounded by steep…Sep 5, 1988 · N111VA · Destroyed NTSB MIA81FA097Accident · Serious injuriesClosedBrittnorman BN-2A · San Juan, PRJul 20, 1981 · N116DW · Destroyed NTSB MIA81DA082Accident · Minor injuriesClosedBrittnorman BN-2A · Nassau (Atlantic Ocean)Jun 2, 1981 · N28377 · Destroyed NTSB ANC78FA012Accident · 1 fatalClosedBrittnorman BN-2A · Toksook Bay, AKJan 20, 1978 · N869JA · Destroyed NTSB MIA78FA016Accident · 5 fatalClosedBrittnorman BN-2A · Vieques, PRDec 19, 1977 · N862JA · Destroyed NTSB ANC77FA062Accident · 1 fatalClosedBrittnorman BN-2H · Ruby, AKJul 21, 1977 · N22JA · Substantial damage NTSB FTW75AF016Accident · No injuriesClosedBrittnorman BN-2A · Baton Rouge, LASep 10, 1974 · N80CA · Substantial damage NTSB MIA74OKA05Accident · No injuriesClosedBrittnorman BN-2A · Santo Domingo, DRSep 17, 1973 · N869JA · Substantial damage NTSB MIA72DKA05Accident · No injuriesClosedBrittnorman BN-2A · No.Atlantic Ocean (Atlantic Ocean)Oct 7, 1971 · N857JA · Destroyed NTSB MIA71AM024Accident · 1 fatalClosedBrittnorman BN-2A · Orocovis, PRSep 9, 1970 · N855JA · Destroyed NTSB MIA70A0031Accident · 2 fatalClosedBrittnorman BN-2A · Missing AircraftOct 11, 1969 · N852JA · Destroyed

Back to Britten-Norman BN-2A