NTSB investigations, 2007

9 cases where the first occurrence was “Collision between aircraft (other than midair)”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19942026

NTSB investigations, 2007 per year, 1994–2026: 139 cases
1994	7
1995	12
1996	15
1997	12
1998	11
1999	9
2000	9
2001	15
2002	8
2003	10
2004	6
2005	10
2006	6
2007	9

Where

Open the map

Latest cases

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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 2007 AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 271) 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE year(c.\"eventDate\") = 2007
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 271)
  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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE year(c."eventDate") = 2007
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 271)
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 NYC08LA062Accident · No injuriesLimited investigationFinal reportBoeing B747-433BCF · New York, NYThe infringement of the parked EMB-190 into the airport movement area, and the B-747 crew's failure to maintain separation between the airplanes in conditions of darkness. Contributing to the accident was the contaminated ramp, which obscured airport markings.Dec 14, 2007 · B-2477 · 2 aircraft · Substantial damage NTSB MIA08LA014Accident · No injuriesLimited investigationFinal reportCessna C208B · Opa Locka, FLFailure of the local controller to coordinate with the ground controller and the failure of the pilots to see and avoid each other.Nov 6, 2007 · N701SE · 2 aircraft · Substantial damage NTSB SEA08LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Phoenix, AZThe failure of the solo student pilot operating the other airplane to maintain clearance while taxiing for takeoff.Oct 30, 2007 · N309PA · 2 aircraft · Substantial damage NTSB LAX08LA004Accident · No injuriesLimited investigationFinal reportYakovlev YAK-50 · El Cajon, CAThe inadequate visual lookout of the pilot of another airplane and his failure to maintain clearance from a taxiing airplane.Oct 6, 2007 · N509RA · 2 aircraft · Minor damage NTSB NYC07LA209Accident · No injuriesLimited investigationFinal reportNorth American SNJ-2 · Farmingdale, NYThe number 5 airplane pilot's inadequate visual lookout.Sep 2, 2007 · N62382 · 2 aircraft · Substantial damage NTSB SEA07LA101Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Llano, CAThe failure of the other pilot to maintain directional control during landing roll.Apr 13, 2007 · N101JJ · 2 aircraft · Substantial damage NTSB SEA07LA081Accident · No injuriesLimited investigationFinal reportCessna T210N · Livermore, CAThe pilot's failure to maintain clearance from another aircraft holding on the taxiway while taxiing from landing. The pilot's inadequate visual lookout was a factor.Mar 24, 2007 · N4644U · 2 aircraft · Substantial damage NTSB DEN07LA074Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Pueblo, COThe pilot of the North American SNJ-5 warbird's inadequate visual lookout while taxiing, resulting in an on-ground collision with the stationary Grob motor glider.Mar 13, 2007 · N12KY · 2 aircraft · Minor damage NTSB CHI07FA060Accident · Minor injuriesField investigationFinal reportBeechcraft BE99 · Milwaukee, WIThe failure of both pilots to adequately scan for and avoid other aircraft traffic during taxi operations, and the failure of Air Traffic Control to issue a traffic advisory to both of the pilots. A contributing factor to the accident was the night time light…Jan 25, 2007 · N699CZ · 2 aircraft · Substantial damage